{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Client Demographics","ADLs","Medical Needs","Nursing Assessment Indicators","Nighttime Needs","Social and Behavioral Needs","Enhanced or Exceptional","Support Needs Summary","Summary of In-Home Hours","2-1 Review and Approval","Raw Scoring","New Scoring","Control"],"not_rendered":{"images":24,"macros":1,"defined_names":218,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Client Demographics","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"merged":[[0,0,0,16],[1,0,1,12],[2,0,2,2],[2,3,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[3,0,3,2],[3,3,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[4,0,4,2],[4,3,4,8],[4,9,4,10],[4,11,4,16],[5,0,5,5],[5,6,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,2],[6,3,6,4],[6,5,6,10],[6,11,6,13],[6,14,6,16],[7,0,7,3],[7,4,7,7],[7,8,7,9],[7,10,7,12],[7,14,7,16],[8,0,9,3],[8,4,9,7],[8,8,8,9],[8,10,8,12],[8,14,8,16],[9,8,9,10],[9,11,9,16],[10,0,10,7],[10,8,10,12],[10,13,10,16],[11,1,11,7],[11,8,11,12],[11,13,11,15],[12,1,12,7],[12,8,12,12],[12,13,12,15],[13,1,13,7],[13,8,13,12],[13,13,13,15],[14,1,14,7],[14,8,14,12],[14,13,14,15],[15,1,15,7],[15,8,15,12],[15,13,15,15],[16,1,16,7],[16,8,16,12],[16,13,16,15],[17,0,17,2],[17,3,17,4],[17,5,17,7],[17,8,17,9],[17,12,17,13],[23,0,23,2]]}
["Adult In-Home Support Needs Assessment"]
["WARNING: Macros are currently disabled.  If this message persists after workbook initialization, please close this file, then reopen it and select either [Enable Macros] or [Enable Content], whichever option is displayed.\n\n* If you believe you have already enabled Macros/Content then:\n   1. First, select the Ribbon's File tab and, if you see a security warning, select the large [Enable Content v] shield button, \n        then \"Enable All Content\".\n   2. If you don't find a security warning then select the [Fix Me] button to the right, on this sheet."]
["(Legal Name) \nName of Individual",{"$nulls":8},"Date of Birth",{"$nulls":3},"Age",null,{"$f":"IF(OR(L3=\"\",AssessmentDate=\"\"),\n       \"\",\n       IF(DATEDIF(L3,AssessmentDate,\"Y\")=0,\n            DATEDIF(L3,AssessmentDate,\"YM\") & \" Month\" & IF(DATEDIF(L3,AssessmentDate,\"YM\")=1,\"\",\"s\"),\n            IF(DATEDIF(L3,AssessmentDate,\"Y\")=1,\n                 DATEDIF(L3,AssessmentDate,\"M\") & \" Months\",\n                 DATEDIF(L3,AssessmentDate,\"Y\"))))","v":""}]
["Prime #",{"$nulls":8},"Height",{"$nulls":3},"Weight"]
["Service Setting",null,null,"(Select)",{"$nulls":5},"Service Element",null,"(Select)"]
["Did the individual participate in the Assessment?",{"$nulls":5},"(Select)",null,null,"Gender",null,"(Select)"]
["Assessment Type",null,null,"(Select)",{"$nulls":7},"              Date of Assessment"]
["CDDP Services Coordinator or\nBrokerage Personal Agent",{"$nulls":7},"CDDP/County or\nBrokerage",null,"(Select)",null,null,"Phone"]
["Assessor's Name",{"$nulls":7},"Assessor Affiliation",null,"(Select)",null,null,"Phone"]
[{"$nulls":8},"Assessor e-mail Address"]
["Name of Assessment Participants",{"$nulls":7},"Relationship to Individual",{"$nulls":4},"Phone"]
["1.",{"$nulls":7},"(Select)"]
["2.",{"$nulls":7},"(Select)"]
["3.",{"$nulls":7},"(Select)"]
["4.",{"$nulls":7},"(Select)"]
["5.",{"$nulls":7},"(Select)"]
["6.",{"$nulls":7},"(Select)"]
["Start Time",{"$nulls":4},"End Time",{"$nulls":6},"Completion Time",null,{"$f":"IF(D18 = \"\",\"\",IF(I18=\"\",\"\",24*(IF(D18<=I18,I18-D18,I18+1-D18))))","v":""},"hrs.",false]
[]
[]
[]
[]
[]
["ANA version C.105",{"$nulls":12},"Auto-save every ",0," minutes"]

{"sheet":"ADLs","index":1,"n_rows":143,"n_cols":14,"rows_kept":143,"merged":[[2,0,2,1],[3,0,3,1],[9,0,9,1],[10,0,10,1],[13,0,13,1],[14,0,14,1],[21,0,21,1],[22,0,22,1],[25,0,25,1],[26,0,26,1],[33,0,33,1],[34,0,34,1],[37,0,37,1],[38,0,38,1],[47,0,47,1],[48,0,48,1],[51,0,51,1],[52,0,52,1],[59,0,59,1],[60,0,60,1],[63,0,63,1],[65,0,65,1],[72,0,72,1],[73,0,73,1],[76,0,76,1],[77,0,77,1],[85,0,85,1],[86,0,86,1],[89,0,89,1],[90,0,90,1],[97,0,97,1],[98,0,98,1],[101,0,101,1],[102,0,102,1],[109,0,109,1],[110,0,110,1],[113,0,113,1],[114,0,114,1],[120,0,120,1],[121,0,121,1],[124,0,124,1],[125,0,125,1],[131,0,131,1],[132,0,132,1],[135,0,135,1],[136,0,136,1],[142,0,142,1],[143,0,143,1]]}
[{"$nulls":3},"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["TRANSPORTATION"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to provide or coordinate their own transportation to access their community.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can independently access transportation, either by driving, accessing public transportation or arranging rides without assistance.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"ADL1","ComAmb1",true,false]
[null,"Partial Assist: The individual requires some assistance with some aspects of transportation.\n",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"ADL1","ComAmb2",false,false]
[null,"Full Assist: The individual is dependent on full assistance from another person for all aspects of \ntransportation.\n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K9),VALUE(IF(ISERROR(VALUE((MID(K9,LEN(K9)-1,1)))),0,MID(K9,LEN(K9)-1,1))&IF(ISERROR(VALUE(MID(K9,LEN(K9)-0,1))),0,MID(K9,LEN(K9)-0,1))),J10)","v":1},"ADL1","ComAmb3",false,false]
["NOTES"]
[]
[]
[]
["AMBULATION / MOBILITY IN THE HOME AND COMMUNITY"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J15:J21)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's physical ability to move around in the individual's home and community with or without mechanical aids.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can move about in familiar surroundings without assistance from another individual with or without mechanical aids.\n",null,"Independent","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K18),VALUE(IF(ISERROR(VALUE((MID(K18,LEN(K18)-1,1)))),0,MID(K18,LEN(K18)-1,1))&IF(ISERROR(VALUE(MID(K18,LEN(K18)-0,1))),0,MID(K18,LEN(K18)-0,1))),J19)","v":2},"ADL2","HomeAmb1",true,false]
[null,"Partial Assist: The individual is dependent on assistance from another person for some aspect of \nambulation/mobility. \n",null,"Partial Assist","No","None",2,"N/A",null,{"$f":"IF(ISTEXT(K19),VALUE(IF(ISERROR(VALUE((MID(K19,LEN(K19)-1,1)))),0,MID(K19,LEN(K19)-1,1))&IF(ISERROR(VALUE(MID(K19,LEN(K19)-0,1))),0,MID(K19,LEN(K19)-0,1))),J20)","v":2},"ADL2","HomeAmb2",false,false]
[null,"Full Assist: The individual is dependent on assistance from another person for all aspects of \nambulation/mobility.\n",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K20),VALUE(IF(ISERROR(VALUE((MID(K20,LEN(K20)-1,1)))),0,MID(K20,LEN(K20)-1,1))&IF(ISERROR(VALUE(MID(K20,LEN(K20)-0,1))),0,MID(K20,LEN(K20)-0,1))),J21)","v":2},"ADL2","HomeAmb3",false,false]
[null,"Two-Person Assist: The individual requires assistance of two people for all aspects of ambulation/mobility. Documentation required.\n",null,"Two-Person Assist","Yes","None",4,"N/A",null,{"$f":"IF(ISTEXT(K21),VALUE(IF(ISERROR(VALUE((MID(K21,LEN(K21)-1,1)))),0,MID(K21,LEN(K21)-1,1))&IF(ISERROR(VALUE(MID(K21,LEN(K21)-0,1))),0,MID(K21,LEN(K21)-0,1))),J22)","v":2},"ADL2","HomeAmb4",false,false]
["NOTES",{"$nulls":5},"* Same value as \"Full Assist\" to allow the 2:1 Review process to determine whether the score should be increased."]
[]
[]
[]
["TRANSFERRING / POSITIONING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J27:J33)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's physical ability to transfer to and from positioning equipment, bathtub, toilet, chair, bed, wheelchair, auto, etc.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can transfer without assistance from another individual with or without mechanical aids.\n",null,"Independent","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K30),VALUE(IF(ISERROR(VALUE((MID(K30,LEN(K30)-1,1)))),0,MID(K30,LEN(K30)-1,1))&IF(ISERROR(VALUE(MID(K30,LEN(K30)-0,1))),0,MID(K30,LEN(K30)-0,1))),J31)","v":3},"ADL3","Trans1",true,false]
[null,"Partial Assist: The individual can perform the transfer with or without mechanical aids, but requires some assistance by another person for some aspect of transferring.\n",null,"Partial Assist","No","None",2,"N/A",null,{"$f":"IF(ISTEXT(K31),VALUE(IF(ISERROR(VALUE((MID(K31,LEN(K31)-1,1)))),0,MID(K31,LEN(K31)-1,1))&IF(ISERROR(VALUE(MID(K31,LEN(K31)-0,1))),0,MID(K31,LEN(K31)-0,1))),J32)","v":3},"ADL3","Trans2",false,false]
[null,"Full Assist: The individual is dependent on another person for all aspects of transferring and positioning.\n",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K32),VALUE(IF(ISERROR(VALUE((MID(K32,LEN(K32)-1,1)))),0,MID(K32,LEN(K32)-1,1))&IF(ISERROR(VALUE(MID(K32,LEN(K32)-0,1))),0,MID(K32,LEN(K32)-0,1))),J33)","v":3},"ADL3","Trans3",false,false]
[null,"Two-Person Assist: The individual requires assistance of two people for all aspects of transferring and positioning. Documentation required.\n",null,"Two-Person Assist","Yes","None",4,"N/A",null,{"$f":"IF(ISTEXT(K33),VALUE(IF(ISERROR(VALUE((MID(K33,LEN(K33)-1,1)))),0,MID(K33,LEN(K33)-1,1))&IF(ISERROR(VALUE(MID(K33,LEN(K33)-0,1))),0,MID(K33,LEN(K33)-0,1))),J34)","v":3},"ADL3","Trans4",false,false]
["NOTES",{"$nulls":5},"* Same value as \"Full Assist\" to allow the 2:1 Review process to determine whether the score should be increased."]
[]
[]
[]
["EATING / DRINKING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J39:J45)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's physical ability to safely eat or drink, either orally or via tube, and maintain their nutrition and hydration in their home or community.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n\n"]
[]
[null,"Independent: The individual can eat and drink safely and requires no assistance or monitoring while eating or drinking.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K42),VALUE(IF(ISERROR(VALUE((MID(K42,LEN(K42)-1,1)))),0,MID(K42,LEN(K42)-1,1))&IF(ISERROR(VALUE(MID(K42,LEN(K42)-0,1))),0,MID(K42,LEN(K42)-0,1))),J43)","v":4},"ADL4","EatDrink1",true,false]
[null,"Partial Assist - food cut up: The individual requires intermittent assistance and monitoring while eating and drinking, and may require their food to be cut up for them by another person. \n",null,"Partial Assist - food cut up","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K43),VALUE(IF(ISERROR(VALUE((MID(K43,LEN(K43)-1,1)))),0,MID(K43,LEN(K43)-1,1))&IF(ISERROR(VALUE(MID(K43,LEN(K43)-0,1))),0,MID(K43,LEN(K43)-0,1))),J44)","v":4},"ADL4","EatDrink2",false,false]
[null,"Partial Assist - intermittent: The individual requires intermittent assistance and monitoring with eating and drinking but requires food or fluid texture to be altered, per doctor's order, by another person.  *\n",null,"Partial Assist - intermittent","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K44),VALUE(IF(ISERROR(VALUE((MID(K44,LEN(K44)-1,1)))),0,MID(K44,LEN(K44)-1,1))&IF(ISERROR(VALUE(MID(K44,LEN(K44)-0,1))),0,MID(K44,LEN(K44)-0,1))),J45)","v":4},"ADL4","EatDrink3",false,false]
[null,"Full Assist - constant: The individual requires constant assistance and monitoring with eating and drinking to maintain proper nutrition and hydration but does not require food or fluid texture to be altered. \n",null,"Full Assist - constant","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K45),VALUE(IF(ISERROR(VALUE((MID(K45,LEN(K45)-1,1)))),0,MID(K45,LEN(K45)-1,1))&IF(ISERROR(VALUE(MID(K45,LEN(K45)-0,1))),0,MID(K45,LEN(K45)-0,1))),J46)","v":4},"ADL4","EatDrink4",false,false]
[null,"Full Assist - constant/aspiration risk: The individual requires constant assistance and monitoring with eating and drinking to maintain proper nutrition and hydration, and/or to prevent the individual from gagging, choking, and aspirating.  The individual may require alteration in food or fluid texture for safety.  The individual may require medication administration through their tube feeding route. *\n",null,"Full Assist - constant/aspiration risk","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K46),VALUE(IF(ISERROR(VALUE((MID(K46,LEN(K46)-1,1)))),0,MID(K46,LEN(K46)-1,1))&IF(ISERROR(VALUE(MID(K46,LEN(K46)-0,1))),0,MID(K46,LEN(K46)-0,1))),J47)","v":4},"ADL4","EatDrink5",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MEAL PREPARATION"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J53:J59)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section measures the individual's ability to safely prepare meals, including simple meals (with or without assistive devices).    Examples foods items that might be included in a simple meal include sandwiches, frozen entrees, cereal or toast.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can prepare meals without assistance from another person.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K56),VALUE(IF(ISERROR(VALUE((MID(K56,LEN(K56)-1,1)))),0,MID(K56,LEN(K56)-1,1))&IF(ISERROR(VALUE(MID(K56,LEN(K56)-0,1))),0,MID(K56,LEN(K56)-0,1))),J57)","v":5},"ADL5","Meal1",true,false]
[null,"Partial Assist - some meals: The individual can prepare some simple meals but requires assistance from another person for at least some meals to assure a nutritionally adequate diet.\n",null,"Partial Assist - some meals","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K57),VALUE(IF(ISERROR(VALUE((MID(K57,LEN(K57)-1,1)))),0,MID(K57,LEN(K57)-1,1))&IF(ISERROR(VALUE(MID(K57,LEN(K57)-0,1))),0,MID(K57,LEN(K57)-0,1))),J58)","v":5},"ADL5","Meal2",false,false]
[null,"Partial Assist - all meals: The individual requires assistance from another person for some aspects of meal preparation for all meals. \n",null,"Partial Assist - all meals","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K58),VALUE(IF(ISERROR(VALUE((MID(K58,LEN(K58)-1,1)))),0,MID(K58,LEN(K58)-1,1))&IF(ISERROR(VALUE(MID(K58,LEN(K58)-0,1))),0,MID(K58,LEN(K58)-0,1))),J59)","v":5},"ADL5","Meal3",false,false]
[null,"Full Assist: The individual is dependent on full assistance of another person for all aspects of meal preparation. \n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K59),VALUE(IF(ISERROR(VALUE((MID(K59,LEN(K59)-1,1)))),0,MID(K59,LEN(K59)-1,1))&IF(ISERROR(VALUE(MID(K59,LEN(K59)-0,1))),0,MID(K59,LEN(K59)-0,1))),J60)","v":5},"ADL5","Meal4",false,false]
["NOTES"]
[]
[]
[]
["BLADDER AND BOWEL CONTROL"]
[null,"Care for Incontinence, Catheter or Ostomy"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J66:J72)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to care for incontinence of the bladder and/or bowel; or assistance needed to perform catheter care or ostomy care.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual is independent with bladder and bowel control issues, whether the individual is continent, incontinent or has a catheter or an ostomy. Mark independent if the individual is not incontinent, and has neither a catheter or an ostomy.\n",null,"Independent","N/A","None",0,"Toilet4+",null,{"$f":"IF(ISTEXT(K69),VALUE(IF(ISERROR(VALUE((MID(K69,LEN(K69)-1,1)))),0,MID(K69,LEN(K69)-1,1))&IF(ISERROR(VALUE(MID(K69,LEN(K69)-0,1))),0,MID(K69,LEN(K69)-0,1))),J70)","v":6},"ADL6","BladderBowel1",true,false]
[null,"Partial Assist: The individual requires assistance managing incontinence of the bladder and/or bowel, changing incontinence garments, soiled clothing or catheter/ostomy care. * \n",null,"Partial Assist","N/A","None",3,"Toilet4+",null,{"$f":"IF(ISTEXT(K70),VALUE(IF(ISERROR(VALUE((MID(K70,LEN(K70)-1,1)))),0,MID(K70,LEN(K70)-1,1))&IF(ISERROR(VALUE(MID(K70,LEN(K70)-0,1))),0,MID(K70,LEN(K70)-0,1))),J71)","v":6},"ADL6","BladderBowel2",false,false]
[null,"Full Assist: The individual is incontinent of the bladder and/or bowel and is dependent on another person to complete all incontinence care, catheter care and/or ostomy care. .* \n",null,"Full Assist","N/A","None",4,"Toilet4-",null,{"$f":"IF(ISTEXT(K71),VALUE(IF(ISERROR(VALUE((MID(K71,LEN(K71)-1,1)))),0,MID(K71,LEN(K71)-1,1))&IF(ISERROR(VALUE(MID(K71,LEN(K71)-0,1))),0,MID(K71,LEN(K71)-0,1))),J72)","v":6},"ADL6","BladderBowel3",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[null,null," "]
[]
[]
["TOILETING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J78:J84)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to independently use the toilet (including commode, bedpan, and/or urinal), to cleanse after elimination and to adjust clothing.  Choose the option that most accurately reflects the supports required by the individual, which are not due to behaviors."]
[]
[null,"Independent: The individual can manage toileting independently and may use mechanical aids, if required. Mark independent if not applicable.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K81),VALUE(IF(ISERROR(VALUE((MID(K81,LEN(K81)-1,1)))),0,MID(K81,LEN(K81)-1,1))&IF(ISERROR(VALUE(MID(K81,LEN(K81)-0,1))),0,MID(K81,LEN(K81)-0,1))),J82)","v":7},"ADL7","Toilet1",true,false]
[null,"Partial Assist - Cueing: The individual requires verbal cueing and monitoring to complete toileting activities.\n",null,"Partial Assist - cueing","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K82),VALUE(IF(ISERROR(VALUE((MID(K82,LEN(K82)-1,1)))),0,MID(K82,LEN(K82)-1,1))&IF(ISERROR(VALUE(MID(K82,LEN(K82)-0,1))),0,MID(K82,LEN(K82)-0,1))),J83)","v":7},"ADL7","Toilet2",false,false]
[null,"Partial Assist: The individual requires assistance from another person for some aspects of using the toilet for elimination. \n",null,"Partial Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K83),VALUE(IF(ISERROR(VALUE((MID(K83,LEN(K83)-1,1)))),0,MID(K83,LEN(K83)-1,1))&IF(ISERROR(VALUE(MID(K83,LEN(K83)-0,1))),0,MID(K83,LEN(K83)-0,1))),J84)","v":7},"ADL7","Toilet3",false,false]
[null,"Full Assist: The individual is dependent on another person, even with mechanical aids, to assist with some or all parts of using the toilet for elimination. \n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K84),VALUE(IF(ISERROR(VALUE((MID(K84,LEN(K84)-1,1)))),0,MID(K84,LEN(K84)-1,1))&IF(ISERROR(VALUE(MID(K84,LEN(K84)-0,1))),0,MID(K84,LEN(K84)-0,1))),J85)","v":7},"ADL7","Toilet4",false,false]
[]
["NOTES"]
[]
[]
[]
["LAUNDRY AND HOUSEKEEPING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J91:J97)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to perform laundry and housekeeping tasks.  Record current ability, regardless of whether or not the individual currently performs the tasks.  \nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors."]
[]
[null,"Independent:  The individual can perform laundry and housekeeping tasks without assistance.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K94),VALUE(IF(ISERROR(VALUE((MID(K94,LEN(K94)-1,1)))),0,MID(K94,LEN(K94)-1,1))&IF(ISERROR(VALUE(MID(K94,LEN(K94)-0,1))),0,MID(K94,LEN(K94)-0,1))),J95)","v":8},"ADL8","Laundry1",true,false]
[null,"Partial Assist- cueing: The individual requires monitoring, reminders and minor cueing to perform laundry and housekeeping tasks.\n",null,"Partial Assist - cueing","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K95),VALUE(IF(ISERROR(VALUE((MID(K95,LEN(K95)-1,1)))),0,MID(K95,LEN(K95)-1,1))&IF(ISERROR(VALUE(MID(K95,LEN(K95)-0,1))),0,MID(K95,LEN(K95)-0,1))),J96)","v":8},"ADL8","Laundry2",false,false]
[null,"Partial Assist - physical: The individual requires monitoring and some physical assistance from another person for some aspects of laundry and housekeeping.",null,"Partial Assist - physical","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K96),VALUE(IF(ISERROR(VALUE((MID(K96,LEN(K96)-1,1)))),0,MID(K96,LEN(K96)-1,1))&IF(ISERROR(VALUE(MID(K96,LEN(K96)-0,1))),0,MID(K96,LEN(K96)-0,1))),J97)","v":8},"ADL8","Laundry3",false,false]
[null,"Full Assist: The individual is dependent on another person to perform laundry and housekeeping tasks for them.",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K97),VALUE(IF(ISERROR(VALUE((MID(K97,LEN(K97)-1,1)))),0,MID(K97,LEN(K97)-1,1))&IF(ISERROR(VALUE(MID(K97,LEN(K97)-0,1))),0,MID(K97,LEN(K97)-0,1))),J98)","v":8},"ADL8","Laundry4",false,false]
["NOTES"]
[]
[]
[]
["BATHING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J103:J109)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to bathe and wash their hair.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can bathe and wash hair without assistance or supervision.",null,"Independent","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K106),VALUE(IF(ISERROR(VALUE((MID(K106,LEN(K106)-1,1)))),0,MID(K106,LEN(K106)-1,1))&IF(ISERROR(VALUE(MID(K106,LEN(K106)-0,1))),0,MID(K106,LEN(K106)-0,1))),J107)","v":9},"ADL9","Bath1",true,false]
[null,"Partial Assist: The individual requires minor physical assistance, standby monitoring, and/or cueing from another person to bathe and wash their hair.",null,"Partial Assist","No","None",2,"N/A",null,{"$f":"IF(ISTEXT(K107),VALUE(IF(ISERROR(VALUE((MID(K107,LEN(K107)-1,1)))),0,MID(K107,LEN(K107)-1,1))&IF(ISERROR(VALUE(MID(K107,LEN(K107)-0,1))),0,MID(K107,LEN(K107)-0,1))),J108)","v":9},"ADL9","Bath2",false,false]
[null,"Full Assist: The individual is dependent on assistance from another person to bathe them and wash their hair.",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K108),VALUE(IF(ISERROR(VALUE((MID(K108,LEN(K108)-1,1)))),0,MID(K108,LEN(K108)-1,1))&IF(ISERROR(VALUE(MID(K108,LEN(K108)-0,1))),0,MID(K108,LEN(K108)-0,1))),J109)","v":9},"ADL9","Bath3",false,false]
[null,"Two-Person Assist: The individual requires assistance of two people while bathing and washing their \nhair. Documentation of Caregivers' schedules and duties are required.",null,"Two-Person Assist","Yes","None",4,"N/A",null,{"$f":"IF(ISTEXT(K109),VALUE(IF(ISERROR(VALUE((MID(K109,LEN(K109)-1,1)))),0,MID(K109,LEN(K109)-1,1))&IF(ISERROR(VALUE(MID(K109,LEN(K109)-0,1))),0,MID(K109,LEN(K109)-0,1))),J110)","v":9},"ADL9","Bath4",false,false]
["NOTES",{"$nulls":5},"* Same value as \"Full Assist\" to allow the 2:1 Review process to determine whether the score should be increased."]
[]
[]
[]
[" HYGIENE (Includes Oral Hygiene, Shaving)"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J115:J121)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to complete personal hygiene tasks such as facial care, shaving, menses care, and oral care.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n\n\n"]
[]
[null,"Independent: The individual can perform personal hygiene tasks without cues, assistance or supervision.",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K118),VALUE(IF(ISERROR(VALUE((MID(K118,LEN(K118)-1,1)))),0,MID(K118,LEN(K118)-1,1))&IF(ISERROR(VALUE(MID(K118,LEN(K118)-0,1))),0,MID(K118,LEN(K118)-0,1))),J119)","v":10},"ADL10","Hygiene1",true,false]
[null,"Partial Assist: The individual requires assistance with hygiene, which may include prompting and cues to complete some aspect of hygiene activities.",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K119),VALUE(IF(ISERROR(VALUE((MID(K119,LEN(K119)-1,1)))),0,MID(K119,LEN(K119)-1,1))&IF(ISERROR(VALUE(MID(K119,LEN(K119)-0,1))),0,MID(K119,LEN(K119)-0,1))),J120)","v":10},"ADL10","Hygiene2",false,false]
[null,"Full Assist: The individual requires assistance from another person to complete  hygiene \nactivities.",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K120),VALUE(IF(ISERROR(VALUE((MID(K120,LEN(K120)-1,1)))),0,MID(K120,LEN(K120)-1,1))&IF(ISERROR(VALUE(MID(K120,LEN(K120)-0,1))),0,MID(K120,LEN(K120)-0,1))),J121)","v":10},"ADL10","Hygiene3",false,false]
["NOTES"]
[]
[]
[]
["DRESSING & HAIR CARE"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J126:J132)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to dress, undress and/or comb hair.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\n"]
[]
[null,"Independent: The individual can dress, undress and/or comb hair independently or with reminding.",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K129),VALUE(IF(ISERROR(VALUE((MID(K129,LEN(K129)-1,1)))),0,MID(K129,LEN(K129)-1,1))&IF(ISERROR(VALUE(MID(K129,LEN(K129)-0,1))),0,MID(K129,LEN(K129)-0,1))),J130)","v":11},"ADL11","Dress1",true,false]
[null,"Partial Assist: The individual requires assistance from another person, which may include frequent monitoring and cueing for completing some aspect of dressing, undressing and/or combing hair.",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K130),VALUE(IF(ISERROR(VALUE((MID(K130,LEN(K130)-1,1)))),0,MID(K130,LEN(K130)-1,1))&IF(ISERROR(VALUE(MID(K130,LEN(K130)-0,1))),0,MID(K130,LEN(K130)-0,1))),J131)","v":11},"ADL11","Dress2",false,false]
[null,"Full Assist: The individual requires total assistance from another person to dress, undress and/or comb hair.",null,"Full Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K131),VALUE(IF(ISERROR(VALUE((MID(K131,LEN(K131)-1,1)))),0,MID(K131,LEN(K131)-1,1))&IF(ISERROR(VALUE(MID(K131,LEN(K131)-0,1))),0,MID(K131,LEN(K131)-0,1))),J132)","v":11},"ADL11","Dress3",false,false]
["NOTES"]
[]
[]
[]
["SHOPPING AND MONEY MANAGEMENT"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J137:J143)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This Section addresses the individual's ability to manage personal money and to acquire necessary goods and services.   Managing money include budgeting, paying of monthly expenses and necessary purchases, and management of personal spending money. Shopping includes activities such as making a shopping list, manipulating a shopping cart or carrying a basket, making choices among available goods or services to purchase, loading and unloading purchases.  Choose the option that most accurately reflects the supports required by the individual, which are not due to behaviors."]
[]
[null,"Independent:  The individual can manage their own funds and complete shopping activities without assistance.",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K140),VALUE(IF(ISERROR(VALUE((MID(K140,LEN(K140)-1,1)))),0,MID(K140,LEN(K140)-1,1))&IF(ISERROR(VALUE(MID(K140,LEN(K140)-0,1))),0,MID(K140,LEN(K140)-0,1))),J141)","v":12},"ADL12","Money1",true,false]
[null,"Partial Assist: The individual requires some assistance from another person with some aspects of money management and/or shopping.",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K141),VALUE(IF(ISERROR(VALUE((MID(K141,LEN(K141)-1,1)))),0,MID(K141,LEN(K141)-1,1))&IF(ISERROR(VALUE(MID(K141,LEN(K141)-0,1))),0,MID(K141,LEN(K141)-0,1))),J142)","v":12},"ADL12","Money2",false,false]
[null,"Full Assist: The individual requires assistance from person to manage their funds and complete all or most aspects of shopping on their behalf.",null,"Full Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K142),VALUE(IF(ISERROR(VALUE((MID(K142,LEN(K142)-1,1)))),0,MID(K142,LEN(K142)-1,1))&IF(ISERROR(VALUE(MID(K142,LEN(K142)-0,1))),0,MID(K142,LEN(K142)-0,1))),J143)","v":12},"ADL12","Money3",false,false]
["NOTES"]

{"sheet":"Medical Needs","index":2,"n_rows":164,"n_cols":14,"rows_kept":164,"merged":[[2,0,2,1],[3,0,3,1],[9,0,9,1],[10,0,10,1],[13,0,13,1],[14,0,14,1],[20,0,20,1],[21,0,21,1],[24,0,24,1],[25,0,25,1],[31,0,31,1],[32,0,32,1],[35,0,35,1],[36,0,36,1],[42,0,42,1],[43,0,43,1],[46,0,46,1],[47,0,47,1],[55,0,55,1],[56,0,56,1],[59,0,59,1],[60,0,60,1],[67,0,67,1],[68,0,68,1],[71,0,71,1],[72,0,72,1],[79,0,79,1],[80,0,80,1],[83,0,83,1],[84,0,84,1],[92,0,92,1],[93,0,93,1],[96,0,96,1],[97,0,97,1],[108,0,108,1],[109,0,109,1],[112,0,112,1],[113,0,113,1],[163,0,163,1],[164,0,164,1]]}
[{"$nulls":3},"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Value\nMismatch"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["COMMUNICATION - EXPRESSIVE & RECEPTIVE"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to verbally, or through adaptive means, understandably express to others their needs, and to understand information and directions from another person.  If the individual uses adaptive devices, assess support needed when the adaptive device is utilized.\nChoose the option that most accurately reflects the supports required by the individual.\n\n"]
[]
[null,"Independent: The individual can communicate their needs with or without the use of adaptive equipment and requires no assistance from another person.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"Medical1","CommExp1",true,false]
[null,"Partial Assist: The individual requires assistance from another person intermittently to express their needs so others will understand them, or to understand information or directions from another person.  \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"Medical1","CommExp2",false,false]
[null,"Full Assist: The individual requires ongoing assistance from another person every day to express \ntheir needs so others will understand them, and to understand information and directions from another person.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K9),VALUE(IF(ISERROR(VALUE((MID(K9,LEN(K9)-1,1)))),0,MID(K9,LEN(K9)-1,1))&IF(ISERROR(VALUE(MID(K9,LEN(K9)-0,1))),0,MID(K9,LEN(K9)-0,1))),J10)","v":1},"Medical1","CommExp3",false,false]
["NOTES"]
[]
[]
[]
["TELEPHONE & ALTERNATIVE COMMUNICATION SYSTEMS"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J15:J21)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to use a telephone or alternate communication device to call for assistance.  This includes ability to call a caregiver when needed and to make appropriate calls to 911. \nChoose the option that most accurately reflects the supports required by the individual.\n"]
[]
[null,"Independent: The individual can use a telephone or alternate communication device to contact a caregiver when needed, and call 911 when appropriate.\n\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K18),VALUE(IF(ISERROR(VALUE((MID(K18,LEN(K18)-1,1)))),0,MID(K18,LEN(K18)-1,1))&IF(ISERROR(VALUE(MID(K18,LEN(K18)-0,1))),0,MID(K18,LEN(K18)-0,1))),J19)","v":2},"Medical2","CommRec1",true,false]
[null,"Partial Assist: The individual requires some assistance from another person to call for help in some situations. \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K19),VALUE(IF(ISERROR(VALUE((MID(K19,LEN(K19)-1,1)))),0,MID(K19,LEN(K19)-1,1))&IF(ISERROR(VALUE(MID(K19,LEN(K19)-0,1))),0,MID(K19,LEN(K19)-0,1))),J20)","v":2},"Medical2","CommRec2",false,false]
[null,"Full Assist: The individual needs step by step cueing or full physical assistance from another person to call for help.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K20),VALUE(IF(ISERROR(VALUE((MID(K20,LEN(K20)-1,1)))),0,MID(K20,LEN(K20)-1,1))&IF(ISERROR(VALUE(MID(K20,LEN(K20)-0,1))),0,MID(K20,LEN(K20)-0,1))),J21)","v":2},"Medical2","CommRec3",false,false]
["NOTES"]
[]
[]
[]
["SAFETY"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J26:J32)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to recognize, understand and protect themselves from potential hazards or harmful situations in their home or community, which are not due to behaviors.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent: The individual requires no assistance from another person.\n\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K29),VALUE(IF(ISERROR(VALUE((MID(K29,LEN(K29)-1,1)))),0,MID(K29,LEN(K29)-1,1))&IF(ISERROR(VALUE(MID(K29,LEN(K29)-0,1))),0,MID(K29,LEN(K29)-0,1))),J30)","v":3},"Medical3","Safe1",true,false]
[null,"Partial Assist: The individual requires intermittent assistance/monitoring from another person to recognize, understand and protect themselves from hazards or harmful situations or people at home or in the community.\n ",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K30),VALUE(IF(ISERROR(VALUE((MID(K30,LEN(K30)-1,1)))),0,MID(K30,LEN(K30)-1,1))&IF(ISERROR(VALUE(MID(K30,LEN(K30)-0,1))),0,MID(K30,LEN(K30)-0,1))),J31)","v":3},"Medical3","Safe2",false,false]
[null,"Full Assist: The individual requires continual assistance/monitoring to recognize, understand and protect themselves from hazards or harmful situations or people at home or in the community.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K31),VALUE(IF(ISERROR(VALUE((MID(K31,LEN(K31)-1,1)))),0,MID(K31,LEN(K31)-1,1))&IF(ISERROR(VALUE(MID(K31,LEN(K31)-0,1))),0,MID(K31,LEN(K31)-0,1))),J32)","v":3},"Medical3","Safe3",false,false]
["NOTES"]
[]
[]
[]
["FIRE EVACUATION"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J37:J43)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to evacuate the home in an emergency.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent: The individual evacuates with no assistance.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K40),VALUE(IF(ISERROR(VALUE((MID(K40,LEN(K40)-1,1)))),0,MID(K40,LEN(K40)-1,1))&IF(ISERROR(VALUE(MID(K40,LEN(K40)-0,1))),0,MID(K40,LEN(K40)-0,1))),J41)","v":4},"Medical4","Fire1",true,false]
[null,"Partial Assist: The individual requires verbal assistance from another person to safely evacuate during an emergency.\n\n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K41),VALUE(IF(ISERROR(VALUE((MID(K41,LEN(K41)-1,1)))),0,MID(K41,LEN(K41)-1,1))&IF(ISERROR(VALUE(MID(K41,LEN(K41)-0,1))),0,MID(K41,LEN(K41)-0,1))),J42)","v":4},"Medical4","Fire2",false,false]
[null,"Full Assist: The individual must be physically assisted by another person in order to safely evacuate during \nan emergency.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K42),VALUE(IF(ISERROR(VALUE((MID(K42,LEN(K42)-1,1)))),0,MID(K42,LEN(K42)-1,1))&IF(ISERROR(VALUE(MID(K42,LEN(K42)-0,1))),0,MID(K42,LEN(K42)-0,1))),J43)","v":4},"Medical4","Fire3",false,false]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - ORAL"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J48:J54)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's oral medication regimen.\nChoose the option that most accurately reflects the supports required by the individual.\n"]
[]
[null,"Independent: Individual does not take any medication or self administers medication with or without provider oversight.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K51),VALUE(IF(ISERROR(VALUE((MID(K51,LEN(K51)-1,1)))),0,MID(K51,LEN(K51)-1,1))&IF(ISERROR(VALUE(MID(K51,LEN(K51)-0,1))),0,MID(K51,LEN(K51)-0,1))),J52)","v":5},"Medical5","MedOral1",true,false]
[null,"Full Assist - 1 to 4: The individual's medication regimen is totally administered and monitored by another \nperson for their 1 to 4 or less medications. \n",null,"Full Assist - 1 to 4","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K52),VALUE(IF(ISERROR(VALUE((MID(K52,LEN(K52)-1,1)))),0,MID(K52,LEN(K52)-1,1))&IF(ISERROR(VALUE(MID(K52,LEN(K52)-0,1))),0,MID(K52,LEN(K52)-0,1))),J53)","v":5},"Medical5","MedOral2",false,false]
[null,"Full Assist - 5 or 6: The individual's medication regimen is totally administered and monitored by another \nperson for their 5 or 6 medications.* \n",null,"Full Assist - 5 or 6","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K53),VALUE(IF(ISERROR(VALUE((MID(K53,LEN(K53)-1,1)))),0,MID(K53,LEN(K53)-1,1))&IF(ISERROR(VALUE(MID(K53,LEN(K53)-0,1))),0,MID(K53,LEN(K53)-0,1))),J54)","v":5},"Medical5","MedOral3",false,false]
[null,"Full Assist - 7 or more: The individual's medication regimen is totally administered and monitored by \nanother person for their 7 or more medications.* \n",null,"Full Assist - 7 or more","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K54),VALUE(IF(ISERROR(VALUE((MID(K54,LEN(K54)-1,1)))),0,MID(K54,LEN(K54)-1,1))&IF(ISERROR(VALUE(MID(K54,LEN(K54)-0,1))),0,MID(K54,LEN(K54)-0,1))),J55)","v":5},"Medical5","MedOral4",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INHALANTS, TOPICALS, SUPPOSITORIES"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J61:J67)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's inhalants, topicals and suppositories regimen.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent:  Individual does not require any inhalants, topicals or suppository regimen or self administers medication, with or without provider support.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K64),VALUE(IF(ISERROR(VALUE((MID(K64,LEN(K64)-1,1)))),0,MID(K64,LEN(K64)-1,1))&IF(ISERROR(VALUE(MID(K64,LEN(K64)-0,1))),0,MID(K64,LEN(K64)-0,1))),J65)","v":6},"Medical6","MedInhale1",true,false]
[null,"Partial Assist: The individual's inhalants, topicals, suppository regimen can be administered by the individual, but some aspects must be monitored or completed by another person.* \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K65),VALUE(IF(ISERROR(VALUE((MID(K65,LEN(K65)-1,1)))),0,MID(K65,LEN(K65)-1,1))&IF(ISERROR(VALUE(MID(K65,LEN(K65)-0,1))),0,MID(K65,LEN(K65)-0,1))),J66)","v":6},"Medical6","MedInhale2",false,false]
[null,"Full Assist: The individual's inhalants, topicals, suppository regimen must be administered by another \nperson.* \n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K66),VALUE(IF(ISERROR(VALUE((MID(K66,LEN(K66)-1,1)))),0,MID(K66,LEN(K66)-1,1))&IF(ISERROR(VALUE(MID(K66,LEN(K66)-0,1))),0,MID(K66,LEN(K66)-0,1))),J67)","v":6},"Medical6","MedInhale3",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INJECTIONS"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J73:J79)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's medication regimen administered by injecting a medication.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent: The individual does not have any medication administered by injection or self-administers medication, with or without provider support.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K76),VALUE(IF(ISERROR(VALUE((MID(K76,LEN(K76)-1,1)))),0,MID(K76,LEN(K76)-1,1))&IF(ISERROR(VALUE(MID(K76,LEN(K76)-0,1))),0,MID(K76,LEN(K76)-0,1))),J77)","v":7},"Medical7","MedInject1",true,false]
[null,"Partial Assist: The individual administers their regimen of injection by themselves, but some aspects must be monitored or completed by another person. (e.g. insulin) * \n",null,"Partial Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K77),VALUE(IF(ISERROR(VALUE((MID(K77,LEN(K77)-1,1)))),0,MID(K77,LEN(K77)-1,1))&IF(ISERROR(VALUE(MID(K77,LEN(K77)-0,1))),0,MID(K77,LEN(K77)-0,1))),J78)","v":7},"Medical7","MedInject2",false,false]
[null,"Full Assist: The individual's regimen by injection is totally administered and monitored by another person. (e.g. insulin). * \n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K78),VALUE(IF(ISERROR(VALUE((MID(K78,LEN(K78)-1,1)))),0,MID(K78,LEN(K78)-1,1))&IF(ISERROR(VALUE(MID(K78,LEN(K78)-0,1))),0,MID(K78,LEN(K78)-0,1))),J79)","v":7},"Medical7","MedInject3",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["HEALTH MANAGEMENT SUPPORTS - GENERAL"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J85:J91)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to identify and self-direct their physical health \nsupports.  This includes their ability to assist with routine health care decisions and treatments that are not ADL or Medication Management Supports.  \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can identify and communicate pain, discomfort or medical needs.  The individual can access health care in the community independently and follow through with prescribed medication, treatments and dietary requirements. \n\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K88),VALUE(IF(ISERROR(VALUE((MID(K88,LEN(K88)-1,1)))),0,MID(K88,LEN(K88)-1,1))&IF(ISERROR(VALUE(MID(K88,LEN(K88)-0,1))),0,MID(K88,LEN(K88)-0,1))),J89)","v":8},"Medical8","HealthSup1",true,false]
[null,"Individual-Directed Care:  The individual can fully self-direct or manage their care, even though the individual is not physically able to provide their own care.  Care that may be individually directed includes physical care, medication administration, treatments and dietary requirements.  \n",null,"Individual-Directed Care","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K89),VALUE(IF(ISERROR(VALUE((MID(K89,LEN(K89)-1,1)))),0,MID(K89,LEN(K89)-1,1))&IF(ISERROR(VALUE(MID(K89,LEN(K89)-0,1))),0,MID(K89,LEN(K89)-0,1))),J90)","v":8},"Medical8","HealthSup2",false,false]
[null,"Partial Assist and Monitoring:  The individual has difficulty recognizing or explaining if they are having pain, discomfort, and/or they require assistance with medication and routine medical/health care needs therefore requiring periodic or weekly monitoring.  They may require assistance with implementation of medical interventions, treatments or dietary requirements.\n\n",null,"Partial Assist and Monitoring","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K90),VALUE(IF(ISERROR(VALUE((MID(K90,LEN(K90)-1,1)))),0,MID(K90,LEN(K90)-1,1))&IF(ISERROR(VALUE(MID(K90,LEN(K90)-0,1))),0,MID(K90,LEN(K90)-0,1))),J91)","v":8},"Medical8","HealthSup3",false,false]
[null,"Full Assist: The individual's health care is managed through a community health care team, which may include the individual's provider and health care professionals such as primary care physicians, dentist, dietician and psychiatrist.  The individual is not able to explain their health care needs or implement the care plan as outlined by the physician, and has current routine medical/health care order(s) that require daily monitoring and assistance to implement medical interventions, treatments and dietary requirements. *\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K91),VALUE(IF(ISERROR(VALUE((MID(K91,LEN(K91)-1,1)))),0,MID(K91,LEN(K91)-1,1))&IF(ISERROR(VALUE(MID(K91,LEN(K91)-0,1))),0,MID(K91,LEN(K91)-0,1))),J92)","v":8},"Medical8","HealthSup4",false,false]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["COMPLEX HEALTH MANAGEMENT SUPPORTS"]
[{"$f":"IF(INDEX('Raw Scoring'!P1:P18,MAX(J98:J104)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to self-direct their medical care, intervention or treatment needs for complex medical condition(s) which impact all aspects of their care. This section also assesses the individual's ability to assist with, explain and recognize their need for medical care, interventions or treatments for their complex condition(s).\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable:  The individual does not have complex medical conditions.\n",null,"Not Applicable","No","None",0,"HealthCmplx2to1-",null,{"$f":"IF(ISTEXT(K101),VALUE(IF(ISERROR(VALUE((MID(K101,LEN(K101)-1,1)))),0,MID(K101,LEN(K101)-1,1))&IF(ISERROR(VALUE(MID(K101,LEN(K101)-0,1))),0,MID(K101,LEN(K101)-0,1))),J102)","v":9},"Medical9","HealthCmplx1",true,false]
[null,"Independent: The individual can identify and communicate pain, discomfort and/or complex nursing and medical needs; access health care in the community independently and follow through with prescribed medication and treatment plan and dietary requirements.  Their health care needs are stable and predictable.\n",null,"Independent","No","None",0,"HealthCmplx2to1-",null,9,"Medical9","HealthCmplx2",false,false]
[null,"Individual-Directed Care: The individual can fully self-direct or manage their complex medical condition even though they are not physically able to perform the care.  Care that may be directed by the individual includes necessary medical care, medications, treatments, activities of daily living, nutrition and nursing interventions. Their health care needs are stable and predictable.\n",null,"Individual-Directed Care","No","None",1,"HealthCmplx2to1-",null,9,"Medical9","HealthCmplx3",false,false]
[null,"Partial Assist - weekly:  The individual has difficulty explaining and does not recognize the need for care, intervention or treatments for their condition(s).  They require monitoring and direct assistance throughout the week by another person to provide their necessary medical care. Their health care needs are stable and predictable.*\n\n",null,"Partial Assist - weekly","No","None",1,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx4",false,false]
[null,"Partial Assist - 1 to 3 per day:  The individual has difficulty explaining and does not recognize the need for care, intervention or treatments for their condition(s).  They require monitoring and direct assistance 1 to 3 times throughout the day by another person to provide their necessary medical care. Their health care needs are stable and predictable. *\n\n",null,"Partial Assist - 1 to 3 per day","No","None",2,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx5",false,false]
[null,"Full Assist - more than 3 per day: The individual is unable to explain or does not recognize the need for care, intervention or treatments for their condition(s).  They require frequent monitoring and direct assistance more than 3 times throughout the day by another person to provide the necessary medical care. Their health care needs are stable and predictable.* \n",null,"Full Assist - more than 3 per day","No","None",3,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx6",false,false]
[null,"Full Assistance and Monitoring - exclusive focus: The individual is unable to communicate or recognize the need for care, intervention or treatments for their condition(s).  They require exclusive focus by another person for continuous observation and physical assessment throughout the day to provide necessary medical care, medications, treatments, activities of daily living, nutrition and nursing interventions.  This individual requires the establishment of the nursing process to outline treatment plans and establish parameters of care. Their medical condition is unstable. * \n\n",null,"Full Assist and Monitoring - exclusive focus","No","None",4,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx7",false,false]
[null,"Two-Person Assist: Mark this box when the individual has planned medical treatments that require exclusive focus with physical intervention by 2 people to complete the treatments that assure the health and safety of the individual between the hours of 5 A.M. and 10 P.M. * & *** \n\n* See individual indicators for a Nursing Assessment Referral\n*** OIS training, level IF-M. for physical intervention during a medical procedure may be needed.\n",null,"Two-Person Assist","Yes","None","N/A","N/A","Medical9.\n",{"$f":"IF(ISTEXT(K108),VALUE(IF(ISERROR(VALUE((MID(K108,LEN(K108)-1,1)))),0,MID(K108,LEN(K108)-1,1))&IF(ISERROR(VALUE(MID(K108,LEN(K108)-0,1))),0,MID(K108,LEN(K108)-0,1))),#REF!)","v":9},"Medical9","HealthCmplx2to1",false,false]
["NOTES"]
[]
[{"$nulls":3},"** Old, unused \"Nursing\" section removed! **",{"$nulls":6},"Medical10"]
[]
["EQUIPMENT"]
[]
[null,"This section records the individual's use of equipment essential to the individual. \nCheck the boxes for equipment used by the individual."]
[{"$nulls":6},"(Max of…)"]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical11","Mobility1",true,false]
[null,"Cane",null,null,"N/A",null,0,{"$nulls":3},"Medical11","Mobility2",false,false]
[null,"Leg braces",null,null,"N/A",null,2,{"$nulls":3},"Medical11","Mobility3",false,false]
[null,"Walker",null,null,"N/A",null,0,{"$nulls":3},"Medical11","Mobility4",false,false]
[null,"Ankle or foot orthotics",null,null,"N/A",null,2,{"$nulls":3},"Medical11","Mobility5",false,false]
[null,"Arm splints",null,null,"N/A",null,2,{"$nulls":3},"Medical11","Mobility6",false,false]
[null,"Adaptive eating equipment (not tube feeding equipment)",null,null,"N/A",null,1,{"$nulls":3},"Medical11","Mobility7",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical12","Bed1",true,false]
[null,"Hospital bed",null,null,"N/A",null,1,{"$nulls":3},"Medical12","Bed2",false,false]
[null,"Grab bars by bed",null,null,"N/A",null,1,{"$nulls":3},"Medical12","Bed3",false,false]
[null,"Hanging bar above bed",null,null,"N/A",null,1,{"$nulls":3},"Medical12","Bed4",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical13","Bath1",true,false]
[null,"Shower chair",null,null,"N/A",null,1,{"$nulls":3},"Medical13","Bath2",false,false]
[null,"Grab bars in bath room",null,null,"N/A",null,3,{"$nulls":3},"Medical13","Bath3",false,false]
[null,"Shower gurney",null,null,"N/A",null,4,{"$nulls":3},"Medical13","Bath4",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical14","Comm1",true,false]
[null,"Non-electronic communication boards",null,null,"N/A",null,2,{"$nulls":3},"Medical14","Comm2",false,false]
[null,"Electronic communication boards",null,null,"N/A",null,2,{"$nulls":3},"Medical14","Comm3",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical15","Transfer1",true,false]
[null,"Hoyer lift",null,null,"N/A",null,3,{"$nulls":3},"Medical15","Transfer2",false,false]
[null,"Transfer equipment (transfer board)",null,null,"N/A",null,2,{"$nulls":3},"Medical15","Transfer3",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical16","Motion1",true,false]
[null,"Body jacket",null,null,"N/A",null,3,{"$nulls":3},"Medical16","Motion2",false,false]
[null,"Manual wheel chair",null,null,"N/A",null,0,{"$nulls":3},"Medical16","Motion3",false,false]
[null,"Electric power wheel chair",null,null,"N/A",null,0,{"$nulls":3},"Medical16","Motion4",false,false]
[null,"Prone stander",null,null,"N/A",null,2,{"$nulls":3},"Medical16","Motion5",false,false]
[null,"Sidelyer",null,null,"N/A",null,2,{"$nulls":3},"Medical16","Motion6",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,null,"N/A",null,0,{"$nulls":3},"Medical17","Mechan1",true,false]
[null,"Specialized tube feeding equipment*",null,null,"N/A",null,4,{"$nulls":3},"Medical17","Mechan2",false,false]
[null,"Nebulizer*",null,null,"N/A",null,3,{"$nulls":3},"Medical17","Mechan3",false,false]
[null,"C-PAP*",null,null,"N/A",null,3,{"$nulls":3},"Medical17","Mechan4",false,false]
[null,"Oxygen",null,null,"N/A",null,3,{"$nulls":3},"Medical17","Mechan5",false,false]
[null,"Ventilator",null,null,"N/A",null,4,{"$nulls":3},"Medical17","Mechan6",false,false]
[null,"Pulse oxymeter*",null,null,"N/A",null,2,{"$nulls":3},"Medical17","Mechan7",false,false]
[null,"Heart monitor*",null,null,"N/A",null,2,{"$nulls":3},"Medical17","Mechan8",false,false]
[null,"Suctioning equipment",null,null,"N/A",null,4,{"$nulls":3},"Medical17","Mechan9",false,false]
[null,"Vagus nerve stimulator (VNS)",null,null,"N/A",null,3,{"$nulls":3},"Medical17","Mechan10",false,false]
[null,"Diabetic insulin pump",null,null,"N/A",null,3,{"$nulls":3},"Medical17","Mechan11",false,false]
[null,"Baclofen pump",null,null,"N/A",null,2,{"$nulls":3},"Medical17","Mechan12",false,false]
[null,"Prosthetics",null,null,"N/A",null,1,{"$nulls":3},"Medical17","Mechan13",false,false]
[null,"* See individual indicators for a Nursing Assessment Referral"]
["NOTES"]

{"sheet":"Nursing Assessment Indicators","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Nighttime Needs","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[2,0,2,1],[3,0,3,1],[14,0,14,1],[15,0,15,1]]}
[{"$nulls":3},"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Value\nMismatch"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["NIGHTTIME NEEDS "]
[{"$f":"IF(INDEX('Raw Scoring'!J1:J2,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's need for supports and monitoring during nighttime hours.\nChoose the option that most accurately reflects the supports required by the individual due to their disability.\n"]
[]
[null,"Not Applicable\n",null,"Not Applicable","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"Nighttime1","NightMed1",true,false]
[null,"Independent: The individual may or may not have difficulty sleeping but requires no assistance from another person during the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Independent","No","None",0,"N/A",null,1,"Nighttime1","NightMed2",false,false]
[null,"Individual Requires Nighttime Assistance - monthly: The individual requires occasional monitoring throughout the month between the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Nighttime Assist - monthly","No","None",0,"N/A",null,1,"Nighttime1","NightMed3",false,false]
[null,"Individual Requires Nighttime Assistance - weekly: The individual requires occasional monitoring throughout the week between the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Nighttime Assist - weekly","No","None",1,"N/A",null,1,"Nighttime1","NightMed4",false,false]
[null,"Individual Requires Nighttime Assistance - intermittent nightly: The individual requires intermittent nightly assistance from another person 1 or more times per night between the hours of 10:00 P.M. and 5:00 A.M. \n",null,"Nighttime Assist - intermittent nightly","No","None",2,"N/A",null,1,"Nighttime1","NightMed5",false,false]
[null,"Individual Requires Nighttime Assistance - ongoing nightly: The individual requires ongoing assistance from another person who must remain awake and available to respond between the hours of 10:00 P.M. and 5:00 A.M. \n",null,"Nighttime Assist - ongoing nightly","No","None",3,"N/A",null,1,"Nighttime1","NightMed6",false,false]
[null,"Individual Requires Nighttime Exclusive Focus: The individual requires ongoing exclusive focus assistance from another person between the hours of 10:00 P.M. and 5:00 A.M. \n\n",null,"Nighttime 1:1 Assist","No","None",4,"N/A",null,1,"Nighttime1","NightMed7",false,false]
[null,"Individual Requires Nighttime 2:1 Assistance: The individual requires ongoing 2:1 exclusive focus assistance from 2 people between the hours of 10:00 P.M. and 5:00 A.M. \n\n",null,"Nighttime 2:1 Assist","Yes","None",4,"N/A",null,1,"Nighttime1","NightMed8",false,false]
["NOTES",{"$nulls":5},"* Same value as \"Exclusive Focus\" to allow the 2:1 Review process to determine whether the score should be increased."]

{"sheet":"Social and Behavioral Needs","index":5,"n_rows":98,"n_cols":14,"rows_kept":98,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[36,0,36,1],[37,0,37,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[50,0,50,1],[51,0,51,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[64,0,64,1],[65,0,65,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[82,0,82,1],[83,0,83,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[97,0,97,1],[98,0,98,1]]}
[{"$nulls":3},"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Value\nMismatch"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["COMMUNITY INTEGRATION SUPPORT"]
["Accessing and interacting in community settings"]
[{"$f":"IF(INDEX('Raw Scoring'!V:V,MAX(J5:J11)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This item captures the support one needs to initiate, coordinate and complete or develop the skills to complete the steps of different tasks and activities in the community (i.e., bank, post office, library, restaurants, movie theatre, social services, etc.) using typical social standards (following rules, waiting in line, using appropriate language, tone, gestures and physical boundaries).  \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent:  Individual requires no support for these tasks.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"Social1","CmtyAccess1",true,false]
[null,"Infrequent Support:  The individual requires support with community activities on less than a monthly basis, support may include preparation for an activity during which the individual  may or may not require support or cuing during the task or activity.\n",null,"Infrequent Support","N/A","None",1,"N/A",null,1,"Social1","CmtyAccess2",false,false]
[null,"Coordination/Occasional Support:  The individual requires support to prepare for activities in the community, such as cuing, coaching, set-up of visual tools or adaptive devices, practicing/role-playing and/or debriefing. The individual does not require (or rarely requires) monitoring or cuing/coaching while engaging in community activities.\n",null,"Coordination/Occasional Support","N/A","None",2,"N/A",null,1,"Social1","CmtyAccess3",false,false]
[null,"Intermittent  Support:  The individual requires monitoring and intermittent cuing or coaching during some, but not all, community activities.  The individual may also require support to prepare for activities in the community, such as cuing, coaching, set-up of visual tools or adaptive devices, practicing/role-playing and/or debriefing.\n",null,"Intermittent Support","N/A","None",3,"N/A",null,1,"Social1","CmtyAccess4",false,false]
[null,"Full  Support:  The individual requires active monitoring, cuing and coaching during all or almost all community activities.  The individual may also require support to prepare for activities in the community, such as cuing, coaching, set-up of visual tools or adaptive devices, practicing/role-playing and/or debriefing.",null,"Full Support","N/A","None",4,"N/A",null,1,"Social1","CmtyAccess5",false,false]
[null,"Constant Coordination and Support:  The individual requires all aspects of community integration to be initiated and coordinated on their behalf.  The individual requires continual support during all community activities.\n",null,"Constant Coordination and Support","N/A","None",5,"N/A",null,1,"Social1","CmtyAccess6",false,false]
["NOTES"]
[]
["SOCIAL INTERACTION"]
["Coordination, cuing and coaching to facilitate  interactions with others. "]
[{"$f":"IF(INDEX('Raw Scoring'!V:V,MAX(J18:J24)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This item captures the support an individual needs to understand and respond to verbal and non-verbal communication, including the application of common social norms when using verbal and non-verbal communication.  (This item is not about expressing and understanding messages.  See also, \"Communication\" on the Medical tab.) \nInclude the support required for the individual to use or develop skills to use appropriate tone, initiate and participate in conversations, engage in appropriate conversation topics, not divulge personal information, listen to the other person, maintain personal space, use physical contact, make eye contact, turn take in conversations, use facial expressions and body movements, etc.  \n\nChoose the option that most accurately reflects the supports required by the individual.  "]
[]
[null,"Independent:  Individual requires no support.\n",null,"Independent","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K21),VALUE(IF(ISERROR(VALUE((MID(K21,LEN(K21)-1,1)))),0,MID(K21,LEN(K21)-1,1))&IF(ISERROR(VALUE(MID(K21,LEN(K21)-0,1))),0,MID(K21,LEN(K21)-0,1))),J22)","v":2},"Social2","InterPers1",true,false]
[null,"Preparation:  The individual requires some support to prepare or build skills for social interaction, such as cuing, coaching, set-up of visual tools or adaptive devices, practicing/role-playing and/or debriefing. The individual does not require (or rarely requires) monitoring or other support while engaging in social interaction.\n",null,"Preparation","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K22),VALUE(IF(ISERROR(VALUE((MID(K22,LEN(K22)-1,1)))),0,MID(K22,LEN(K22)-1,1))&IF(ISERROR(VALUE(MID(K22,LEN(K22)-0,1))),0,MID(K22,LEN(K22)-0,1))),J23)","v":2},"Social2","InterPers2",false,false]
[null,"Intermittent Support:  The individual requires monitoring and cuing/reminders to initiate and maintain socialization for some but not majority of social activities.  The individual may or may not need support to prepare for the activity.\n",null,"Intermittent Support","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K23),VALUE(IF(ISERROR(VALUE((MID(K23,LEN(K23)-1,1)))),0,MID(K23,LEN(K23)-1,1))&IF(ISERROR(VALUE(MID(K23,LEN(K23)-0,1))),0,MID(K23,LEN(K23)-0,1))),J24)","v":2},"Social2","InterPers3",false,false]
[null,"Frequent Support:  The individual requires monitoring and cuing/reminders to maintain socialization for most social activities. The individual may or may not need support to prepare for the activity.\n",null,"Frequent Support","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K24),VALUE(IF(ISERROR(VALUE((MID(K24,LEN(K24)-1,1)))),0,MID(K24,LEN(K24)-1,1))&IF(ISERROR(VALUE(MID(K24,LEN(K24)-0,1))),0,MID(K24,LEN(K24)-0,1))),J25)","v":2},"Social2","InterPers4",false,false]
[null,"Full Support:  The individual requires ongoing, active verbal or physical supports to maintain socialization in all or almost all socialization activities.\n",null,"Full Support","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K25),VALUE(IF(ISERROR(VALUE((MID(K25,LEN(K25)-1,1)))),0,MID(K25,LEN(K25)-1,1))&IF(ISERROR(VALUE(MID(K25,LEN(K25)-0,1))),0,MID(K25,LEN(K25)-0,1))),J26)","v":2},"Social2","InterPers5",false,false]
["NOTES"]
[]
["BEHAVIORAL SUPPORTS - NO FORMAL PLAN - SUPERVISON AND MONITORING"]
["Supervision and monitoring for behavior and mental health"]
[{"$f":"IF(INDEX('Raw Scoring'!AC:AC,MAX(J30:J36)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to function in a home and community environment with behavioral supports from another person to maintain safety of self and/or others.  \nThese behaviors do not require a formal behavior support plan and are not addressed in a formal BSP.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable:  The individual does not require supervision or monitoring from another person for behavioral issues.\n",null,"Not Applicable","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K33),VALUE(IF(ISERROR(VALUE((MID(K33,LEN(K33)-1,1)))),0,MID(K33,LEN(K33)-1,1))&IF(ISERROR(VALUE(MID(K33,LEN(K33)-0,1))),0,MID(K33,LEN(K33)-0,1))),J34)","v":1},"Behavior1","BehavMin1",true,false]
[null,"Redirecting:  The individual has a transition plan, ISP or mental health guidelines that require redirection \nduring waking hours, to assure the safety of the individual.  This behavior does not require a formal \nbehavior support plan and is not addressed in any formal BSP.\n",null,"Redirecting","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K34),VALUE(IF(ISERROR(VALUE((MID(K34,LEN(K34)-1,1)))),0,MID(K34,LEN(K34)-1,1))&IF(ISERROR(VALUE(MID(K34,LEN(K34)-0,1))),0,MID(K34,LEN(K34)-0,1))),J35)","v":1},"Behavior1","BehavMin2",false,false]
[null,"Within Hearing or Visual Distances:  The individual has a transition plan, ISP or mental health \nguidelines that require supervision for safety, within hearing distance or visual range, during waking hours.  \nThis behavior does not require a formal behavior support plan and is not addressed in any formal BSP.\n",null,"Within Hearing or Visual Distance","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K35),VALUE(IF(ISERROR(VALUE((MID(K35,LEN(K35)-1,1)))),0,MID(K35,LEN(K35)-1,1))&IF(ISERROR(VALUE(MID(K35,LEN(K35)-0,1))),0,MID(K35,LEN(K35)-0,1))),J36)","v":1},"Behavior1","BehavMin3",false,false]
[null,"Within Hearing and Visual Distances:  The individual has a transition plan, ISP or mental health \nguidelines requiring visual range and hearing distance supervision during waking hours.  This behavior \ndoes not require a formal behavior support plan and is not addressed in any formal BSP.\n",null,"Within Hearing and Visual Distance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K36),VALUE(IF(ISERROR(VALUE((MID(K36,LEN(K36)-1,1)))),0,MID(K36,LEN(K36)-1,1))&IF(ISERROR(VALUE(MID(K36,LEN(K36)-0,1))),0,MID(K36,LEN(K36)-0,1))),J37)","v":1},"Behavior1","BehavMin4",false,false]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"]
["Supervision, monitoring and plans for behavior and mental health"]
[{"$f":"IF(INDEX('Raw Scoring'!AC:AC,MAX(J43:J49)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to function in a home and community environment with behavioral supports and intervention from another person to maintain safety of self and/or others.  \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable:  The individual does not have behavioral or mental health needs that require a plan.\n",null,"Not Applicable","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K46),VALUE(IF(ISERROR(VALUE((MID(K46,LEN(K46)-1,1)))),0,MID(K46,LEN(K46)-1,1))&IF(ISERROR(VALUE(MID(K46,LEN(K46)-0,1))),0,MID(K46,LEN(K46)-0,1))),J47)","v":2},"Behavior2","BehavFormal1",true,false]
[null,"Behavior Plan - No Physical Interventions:  The individual has a behavior support need that may require a formal behavior plan, which does not include physical intervention(s). *\n",null,"Behavior Plan - No Physical Interventions","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K47),VALUE(IF(ISERROR(VALUE((MID(K47,LEN(K47)-1,1)))),0,MID(K47,LEN(K47)-1,1))&IF(ISERROR(VALUE(MID(K47,LEN(K47)-0,1))),0,MID(K47,LEN(K47)-0,1))),J48)","v":2},"Behavior2","BehavFormal2",false,false]
[null,"Behavior Plan:  The individual has a behavior support need that requires a formal behavior plan, which does include physical intervention(s). ** &***\n",null,"Behavior Plan - Physical Interventions","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K48),VALUE(IF(ISERROR(VALUE((MID(K48,LEN(K48)-1,1)))),0,MID(K48,LEN(K48)-1,1))&IF(ISERROR(VALUE(MID(K48,LEN(K48)-0,1))),0,MID(K48,LEN(K48)-0,1))),J49)","v":2},"Behavior2","BehavFormal3",false,false]
[null,"Mental Health Plan:  The individual has a mental health support need that requires mental health guidelines written by a mental health professional.  The mental health plan may include a crisis response plan. ***",null,"Mental Health Plan","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K49),VALUE(IF(ISERROR(VALUE((MID(K49,LEN(K49)-1,1)))),0,MID(K49,LEN(K49)-1,1))&IF(ISERROR(VALUE(MID(K49,LEN(K49)-0,1))),0,MID(K49,LEN(K49)-0,1))),J50)","v":2},"Behavior2","BehavFormal4",false,false]
[null,"If you check any questions in the behavioral section marked with a * then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan.\n** OIS training is required for all paid providers."]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISON - HOME"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[{"$f":"IF(INDEX('Raw Scoring'!AC:AC,MAX(J57:J63)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to function in the home with supports and interventions from another person to maintain safety of self and/or others. \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable:  The individual does not require supervision or monitoring from another person for behavioral issues.\n",null,"Not Applicable","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K60),VALUE(IF(ISERROR(VALUE((MID(K60,LEN(K60)-1,1)))),0,MID(K60,LEN(K60)-1,1))&IF(ISERROR(VALUE(MID(K60,LEN(K60)-0,1))),0,MID(K60,LEN(K60)-0,1))),J61)","v":3},"Behavior3","BehavPlan1",true,false]
[null,"Redirecting:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require redirection during waking hours, to assure the safety of the individual. *\n",null,"Redirecting","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K61),VALUE(IF(ISERROR(VALUE((MID(K61,LEN(K61)-1,1)))),0,MID(K61,LEN(K61)-1,1))&IF(ISERROR(VALUE(MID(K61,LEN(K61)-0,1))),0,MID(K61,LEN(K61)-0,1))),J62)","v":3},"Behavior3","BehavPlan2",false,false]
[null,"Within Hearing or Visual Distances:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require supervision of the individual to be within hearing or visual distance. *\n",null,"Within Hearing or Visual Distance","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K62),VALUE(IF(ISERROR(VALUE((MID(K62,LEN(K62)-1,1)))),0,MID(K62,LEN(K62)-1,1))&IF(ISERROR(VALUE(MID(K62,LEN(K62)-0,1))),0,MID(K62,LEN(K62)-0,1))),J63)","v":3},"Behavior3","BehavPlan3",false,false]
[null,"Within Hearing and Visual Distances:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require supervision of the individual to be within hearing and visual distance. *\n",null,"Within Hearing and Visual Distance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K63),VALUE(IF(ISERROR(VALUE((MID(K63,LEN(K63)-1,1)))),0,MID(K63,LEN(K63)-1,1))&IF(ISERROR(VALUE(MID(K63,LEN(K63)-0,1))),0,MID(K63,LEN(K63)-0,1))),J64)","v":3},"Behavior3","BehavPlan4",false,false]
[null,"If you check any questions in the behavioral section marked with a * then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan."]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - HOME - EXCLUSIVE FOCUS"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[{"$f":"IF(INDEX('Raw Scoring'!AC1:AC5,MAX(J71:J77)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual’s need for supervision and monitoring requiring the “exclusive focus” of a caregiver to maintain safety of self and/or others.\n\nExclusive focus means that the caregiver must provide complete and uninterrupted attention to the individual to the degree that no other task can completed while the caregiver is responsible for the supervision of the individual including supervision of children or other adults requiring care, household tasks, or personal social or recreational activity.\n\nThe need for exclusive focus supervision and monitoring must be based on a pattern of behavior that either a) has resulted in injury to the individual or others that required professional medical attention; or b) presents a direct and significant risk of injury severe enough to require professional medical attention.\n\nNOTE REQUIRED:  If Exclusive Focus hours are recorded in this section, the type of behavior(s), history of injury, and frequency/duration of episodes of behavior of an intensity likely to result in injury must be recorded\n in the notes field. "]
[]
[null,"Not Applicable: The individual does not require Exclusive Focus supervision in the home.\n",null,"Not Applicable","No","None",0,"InHome2to1-",null,{"$f":"IF(ISTEXT(K74),VALUE(IF(ISERROR(VALUE((MID(K74,LEN(K74)-1,1)))),0,MID(K74,LEN(K74)-1,1))&IF(ISERROR(VALUE(MID(K74,LEN(K74)-0,1))),0,MID(K74,LEN(K74)-0,1))),J75)","v":4},"Behavior4","BehavInHome1",true,false]
[null,"Exclusive Focus - 2:  The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 2 hours a day.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"One-on-One - 2","No","None",1,"InHome2to1+",null,4,"Behavior4","BehavInHome2",false,false]
[null,"Exclusive Focus - 4: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 4 hours a day.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"One-on-One - 4","No","None",2,"InHome2to1+",null,4,"Behavior4","BehavInHome3",false,false]
[null,"Exclusive Focus - 6: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 6 hours a day.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"One-on-One - 6","No","None",3,"InHome2to1+",null,4,"Behavior4","BehavInHome4",false,false]
[null,"Exclusive Focus - 8: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 8 hours a day.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"One-on-One - 8","No","None",4,"InHome2to1+",null,4,"Behavior4","BehavInHome5",false,false]
[null,"Exclusive Focus - 10: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 10 hours a day.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.",null,"One-on-One - 10","No","None",5,"InHome2to1+",null,4,"Behavior4","BehavInHome6",false,false]
[null,"Exclusive Focus - 12: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require Exclusive Focus supervision.  A caregiver must maintain an exclusive focus on the individual between the hours of 5:00 A.M. and 10:00 P.M. up to 12 hours a day.  *\nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"One-on-One - 12","No","None",6,"InHome2to1+",null,4,"Behavior4","BehavInHome7",false,false]
[null,"Two-Person Exclusive Focus: The individual has or needs a formal behavior plan, has a legal order or mental health guidelines that require 2:1 Exclusive Focus on the individual between the hours of  5:00 A.M. and 10:00 P.M.  **\nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedules and duties is required.\n",null,"Two-Person Assist","Yes","None","N/A","N/A","Behavior4.\n",4,"Behavior4","InHome2to1",false,false]
[null,"If you check any questions in the behavioral section marked with a * then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan."]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the \ncommunity."]
[{"$f":"IF(INDEX('Raw Scoring'!V1:V4,MAX(J89:J95)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to function in the community with supports and interventions from another person to maintain safety of self and/or others.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable: The individual does not require supervision or monitoring from another person for behavioral issues in the community.\n",null,"Not Applicable","No","None",0,"CmtyBehav2to1-",null,{"$f":"IF(ISTEXT(K92),VALUE(IF(ISERROR(VALUE((MID(K92,LEN(K92)-1,1)))),0,MID(K92,LEN(K92)-1,1))&IF(ISERROR(VALUE(MID(K92,LEN(K92)-0,1))),0,MID(K92,LEN(K92)-0,1))),J93)","v":3},"Social3","CmtyBehav1",true,false]
[null,"Within Hearing or Visual Distance: The individual has or may need a formal behavior plan, legal order, or mental health guidelines that require supervision of the individual to be within hearing or visual distance while in the community.  *\n\n",null,"Within Hearing or Visual Distance","No","None",3,"CmtyBehav2to1+",null,{"$f":"IF(ISTEXT(K93),VALUE(IF(ISERROR(VALUE((MID(K93,LEN(K93)-1,1)))),0,MID(K93,LEN(K93)-1,1))&IF(ISERROR(VALUE(MID(K93,LEN(K93)-0,1))),0,MID(K93,LEN(K93)-0,1))),J94)","v":3},"Social3","CmtyBehav2",false,false]
[null,"Within Hearing and Visual Distance: The individual has or may need a formal behavior plan, legal order, or mental health guidelines that require supervision of the individual to be within hearing and visual distance while in the community.  *\n\n",null,"Within Hearing and Visual Distance","No","None",4,"CmtyBehav2to1+",null,{"$f":"IF(ISTEXT(K94),VALUE(IF(ISERROR(VALUE((MID(K94,LEN(K94)-1,1)))),0,MID(K94,LEN(K94)-1,1))&IF(ISERROR(VALUE(MID(K94,LEN(K94)-0,1))),0,MID(K94,LEN(K94)-0,1))),J95)","v":3},"Social3","CmtyBehav3",false,false]
[null,"Exclusive Focus:  The individual has or may need a formal behavior plan, has a legal order or mental health \nguidelines that require Exclusive Focus supervision in the community.  A caregiver must maintain an exclusive \nfocus on the individual while in the community.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"One-on-One","No","None",4,"CmtyBehav2to1+",null,{"$f":"IF(ISTEXT(K95),VALUE(IF(ISERROR(VALUE((MID(K95,LEN(K95)-1,1)))),0,MID(K95,LEN(K95)-1,1))&IF(ISERROR(VALUE(MID(K95,LEN(K95)-0,1))),0,MID(K95,LEN(K95)-0,1))),J96)","v":3},"Social3","CmtyBehav4",false,false]
[null,"Two-Person Exclusive Focus: The individual has or needs a formal behavior plan, has a legal order or mental health guidelines that require 2:1 exclusive focus on the individual while in the community.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedules and duties is required.\n",null,"Two-Person Assist","Yes","None","N/A","N/A","Social3.\n",{"$f":"IF(ISTEXT(K96),VALUE(IF(ISERROR(VALUE((MID(K96,LEN(K96)-1,1)))),0,MID(K96,LEN(K96)-1,1))&IF(ISERROR(VALUE(MID(K96,LEN(K96)-0,1))),0,MID(K96,LEN(K96)-0,1))),J97)","v":3},"Social3","CmtyBehav2to1",false,false]
[null,"If you check any questions in the behavioral section marked with a * then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan."]
["NOTES"]

{"sheet":"Enhanced or Exceptional","index":6,"n_rows":42,"n_cols":14,"rows_kept":42,"merged":[[31,0,31,1],[42,0,42,1]]}
[{"$nulls":3},"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Value\nMismatch"]
[null,"Rating selections must be applied in accordance with “Enhanced/Exceptional Insert to the ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["ENHANCED or EXCEPTIONAL NEEDS "]
[]
[]
[null,"Nursing Tasks:  check the box for all nursing tasks for which the individual requires physical assistance from a caregiver.  Do not include tasks that the individual completes independently and for which the individual requires only monitoring, reminders or cuing.  Do not include tasks which are performed in a clinical setting by professional staff or which are performed by home health nurse."]
[]
[null,"Ventilator -- Mechanical ventilation monitoring and care (does not include CPAP/BiPAP).",{"$nulls":4},4,{"$nulls":3},"EE_Nursing1","Ventilator1",false,false]
[null,"CPAP/BiPAP -- Individual requires daily assistance and monitoring use of CPAP or BiPAP.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","CPAP2",false,false]
[null,"Oxygen -- Administration and monitoring of oxygen on a daily or near daily basis.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Oxygen3",false,false]
[null,"Extensive respiratory treatment - respiratory treatment, one or more times daily, such as: chest percussion (including use of percussion vest), postural drainage, nebulizer or tracheal aerosol therapy.  Do not include use of inhaler(s), oxygen or suctioning.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Resp4",false,false]
[null,"Tracheotomy care - includes maintenance/cuff inflation.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Trach5",false,false]
[null,"Suctioning airway, tracheal or nasopharyngeal suctioning one or more times daily to prevent aspiration.  Do not check when suctioning is limited to the oral cavity.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Suction6",false,false]
[null,"Stoma care -- includes cleansing and dressing changes at the opening where the tube (e.g. tracheostomy, colostomy, gastrostomy or urostomy) enter the body.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Stoma7",false,false]
[null,"Tube feeding -- Feedings administered via nasogastric, gastrostomy or jejunostomy tube one or more times every day.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","FeedingTube8",false,false]
[null,"Diabetes management which includes all of the following components: daily blood glucose testing and administration of sliding scale insulin by the caregiver and management of diabetic diet.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Diabetes9",false,false]
[null,"Central Line, Intravenous (IV) injections/infusions; and/or daily intramuscular or subcutaneous injections -- include only those injections/infusions administered by a caregiver.  Do not include injections/infusions administered by a medical professional in a clinical setting or providing support through a hospice or outpatient program.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Injection10",false,false]
[null,"Dialysis -- peritoneal dialysis or hemodialysis administered by the caregiver in the home.  Do not include dialysis treatments administered in a clinical setting.",{"$nulls":4},3,{"$nulls":3},"EE_Nursing1","Dialysis11",false,false]
[null,"Shunt (cerebral) -- Includes daily documented neuro-checks.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Shunt12",false,false]
[null,"Vital sign monitoring (temperature, respiration, heart rate and blood pressure) one or more times per day when results are recorded as ordered by the primary care provider.  Do not include monitoring that does not include documentation of results or was not ordered by the primary care provider.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","VitalSigns13",false,false]
[null,"Seizure interventions (treatments) required on 2 or more days per month, not including scheduled medications.  Count only medical treatments ordered to stop the seizure(s).  Do not include monitoring, timing of seizures, removing dangerous objects or other actions a caregiver may perform but which are not a treatment to stop the seizure(s).",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","Seisure14",false,false]
[null,"Baclofen pump -- close monitoring for adverse effects. ",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","MedPump15",false,false]
[null,"Wound care/ulcer care other than amputation site  care -- Include open wounds which require assessment by a medical professional to evaluate appropriate treatment, and stage III or IV ulcers ( a skin ulcer, including pressure sores, which results in full loss of skin and tissue and may extend into muscle or bone.)    Do not include minor injuries requiring only first aid, or preventative treatment for an individual who is at risk, but does not currently have a stage III or IV skin ulcer.",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","WoundCare16",false,false]
[null,"Amputation site care for new amputation.  Includes monitoring for infection, application and monitoring of compression bandage.  ",{"$nulls":4},2,{"$nulls":3},"EE_Nursing1","SumpCare17",false,false]
[null,"Colostomy/Urostomy/Ileostomy care -- monitoring, tracking and disposal of output, and maintenance of ostomy device/tubing.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Ostomy18",false,false]
[null,"Digital Stimulation/Impaction removal -- Individual requires digital stimulation of the bowel or digital removal of stool lodged in the rectum on a daily or near daily basis.  Do not include other bowel care.  Do not include care performed by a medical professional other than the caregiver.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","ImpactionCare19",false,false]
[null,"Urinary Catheterization --Care must be daily or more frequently.  Includes care for indwelling catheter or suprapubic catheter or insertion of a catheter (intermittent catheterization.).  Does not include use of a condom catheter.",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Cath20",false,false]
[null,"Mechanical Lift/Stander/Sidelyer/Body Jacket -- individual requires use of a mechanical lift for all transfers or requires a stander, sidelyer and/or body jacket on a daily basis. ",{"$nulls":4},1,{"$nulls":3},"EE_Nursing1","Positioning21",false,false]
[null,"Requires awake caregiver 20 or more hours per day to monitor medical status and complete nursing tasks.\n*Count only if an awake caregiver is required 20 or more hours per day on a daily basis.\n*Do not check if awake caregiver is occasionally required 20 or more hours per day.\n*Do not check if the individual has an altered sleep schedule but routinely has a period of more than 4\n   hours during day during which an awake caregiver is not required.\n*Count only if medical needs include a risk to health and safety and cannot safely be addressed through\n   adaptations such as medical alarms. \n",{"$nulls":4},true,{"$nulls":3},"EE_Nursing1","TwentyHrs22",false,false]
[null,"None of the above",{"$nulls":4},true,{"$nulls":3},"EE_Nursing1","None23",false,false]
["NOTES"]
[]
[]
[null,"Behavior Supports:  Check all that are true.  Record only plans and interventions that are actually in place at the time of this assessment.  (Note: this is a different basis than is applied to the similar questions on the behavior tab.)"]
[]
[null,"Behavior Support Plan implementation - individual has a Behavior Support Plan (or Mental Health Plan) which includes specific proactive supports, reactive supports and crisis supports.  The plan is currently being implemented by caregivers and caregivers document the incidence of behaviors.  Include only behavior support plans or mental health plans which address behaviors that are dangerous or have a significant negative impact to the individual's ability to complete or receive support for ADL, IADL or health related activities.\n\n* Do not include behavior guideline, interaction guideline or safety guideline documents that are not a full BSP.\n\n* Do not include behavior documents that are designed to be implemented by the individual rather than by the caregiver.",{"$nulls":4},3,"SupPlanRevised2\nCmplxTools3\nPPI4\nTwentyHrs5",null,null,"EE_Behav1","SupPlanImpl1",false,false]
[null,"Behavior Support Plan Revision -- the individual's Behavior Support Plan has been revised 2 or more times in the last 12 months to address new behaviors, or to address significant changes in behavior or significant changes in the effectiveness of the behavior support strategies.  A significant change is one which results in the addition or substitution of a behavior support strategy not previously contained in the plan.  Significant changes do not include adjustments to existing strategies such as changing the type of reward provided when a behavior goal is met or adjustment of visual tools used to implement the plan.",{"$nulls":4},1,null,"SupPlanImpl1.\n",null,"EE_Behav1","SupPlanRevised2",false,false]
[null,"Development of complex tools used in BSP -- the individual’s BSP includes complex behavior support tools that must be developed and significantly altered by a caregiver one or more times per month.  Complex behavior support tools are tools that require specific training to develop and adapt such as social stories or visual structure systems.  These tools must be developed and adapted by the caregiver as new triggers are encountered or changes in behavior occur.  Do not include tools developed by someone other than the caregiver or minor changes to existing or prefabricated tools.",{"$nulls":4},1,null,"SupPlanImpl1.\n",null,"EE_Behav1","CmplxTools3",false,false]
[null,"Protective Physical Interventions -- the individual has a behavior support plan which includes protective physical interventions;  AND protective physical interventions have been used to keep the individual safe in crisis situations at one of the following intervals:\n-PPIs (not including deflection, evasion or body positioning) have been needed 3 or more times in the last 6 months; OR\n-PPIs (not including deflection, evasion or body positioning) have been needed 5 or more times in the last 12 months; OR\n-PPIs, including deflection, evasion , or body positioning maneuvers have been needed at least weekly throughout the last 6 months; OR \n-Individual has had a BSP which includes PPIs for less than 6 months AND the emergency services, crisis intervention services or protective services were utilized to address  a dangerous behavior 2 or more times in the past 12 months.",{"$nulls":4},1,null,"SupPlanImpl1.\n",null,"EE_Behav1","PPI4",false,false]
[null,"Requires awake caregiver 20 or more hours per day to provide behavior supports.  Individual has behaviors which occur during both day and nighttime hours and could not be safely addressed without active supervision by an awake caregiver.\n\n*Count only if an awake caregiver is required 20 or more hours per day on a daily basis.\n*Do not check if awake caregiver is occasionally required 20 or more hours per day.\n*Do not check if the individual has an altered sleep schedule but routinely has a sleep period of more than 4\n   hours per day during which an awake caregiver is not required.\n*Count only if behaviors include a risk to health and safety and cannot safely be addressed through\n   environmental adaptations. \n",{"$nulls":4},true,null,"SupPlanImpl1.\n",null,"EE_Behav1","TwentyHrs5",false,false]
[null,"None of the above",{"$nulls":4},true,{"$nulls":3},"EE_Behav1","None6",false,false]
["NOTES"]

{"sheet":"Support Needs Summary","index":7,"n_rows":181,"n_cols":4,"rows_kept":181,"merged":[[147,0,148,0],[155,0,156,0]]}
["SUPPORT NEEDS SUMMARY"]
[]
["ADLs","Support Needs Category"]
[null,{"$f":"ADLs!A3","v":"TRANSPORTATION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A14","v":"AMBULATION / MOBILITY IN THE HOME AND COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A26","v":"TRANSFERRING / POSITIONING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A38","v":"EATING / DRINKING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A52","v":"MEAL PREPARATION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A64","v":"BLADDER AND BOWEL CONTROL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A77","v":"TOILETING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A90","v":"LAUNDRY AND HOUSEKEEPING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A102","v":"BATHING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A114","v":" HYGIENE (Includes Oral Hygiene, Shaving)"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A125","v":"DRESSING & HAIR CARE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A136","v":"SHOPPING AND MONEY MANAGEMENT"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
["Medical Needs","Support Needs Category"]
[null,{"$f":"'Medical Needs'!A3","v":"COMMUNICATION - EXPRESSIVE & RECEPTIVE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A14","v":"TELEPHONE & ALTERNATIVE COMMUNICATION SYSTEMS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A25","v":"SAFETY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A36","v":"FIRE EVACUATION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A47","v":"MEDICATION MANAGEMENT SUPPORTS - ORAL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A60","v":"MEDICATION MANAGEMENT SUPPORTS - INHALANTS, TOPICALS, SUPPOSITORIES"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A72","v":"MEDICATION MANAGEMENT SUPPORTS - INJECTIONS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A84","v":"HEALTH MANAGEMENT SUPPORTS - GENERAL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!A97","v":"COMPLEX HEALTH MANAGEMENT SUPPORTS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Med. Enh./Except.","(None)"]
[null,"Ventilator monitoring and care"]
[null,"CPAP/BiPAP assistance and monitoring"]
[null,"Oxygen administration and monitoring"]
[null,"Extensive respiratory treatment"]
[null,"Tracheotomy care"]
[null,"Suctioning airway"]
[null,"Stoma care"]
[null,"Tube feeding"]
[null,"Diabetes management"]
[null,"Injections/infusions"]
[null,"Dialysis (by the caregiver in the home)"]
[null,"Shunt (cerebral) monitoring and care"]
[null,"Monitoring of vital signs"]
[null,"Seizure interventions"]
[null,"Baclofen pump monitoring and assistance"]
[null,"Wound care/ulcer care"]
[null,"Stump care for new amputation"]
[null,"Colostomy/urostomy/ileostomy care"]
[null,"Impaction removal"]
[null,"Urinary catheterization"]
[null,"Mechanical lift, stander, sidelyer, or bodyJacket"]
[null,"Awake caregiver required 20 or more hours per day"]
["Equipment","(None)"]
[null,"Cane"]
[null,"Leg braces"]
[null,"Walker"]
[null,"Ankle or foot orthotics"]
[null,"Arm splints"]
[null,"Adaptive eating equipment (not tube feeding equipment)"]
[null,"Hospital bed"]
[null,"Grab bars by bed"]
[null,"Hanging bar above bed"]
[null,"Shower chair"]
[null,"Grab bars in bathroom"]
[null,"Shower gurney"]
[null,"Non-electronic communication boards"]
[null,"Electronic communication boards"]
[null,"Hoyer lift"]
[null,"Transfer equipment (transfer board)"]
[null,"Body jacket"]
[null,"Manual wheel chair"]
[null,"Electric power wheel chair"]
[null,"Prone stander"]
[null,"Sidelyer"]
[null,"Specialized tube feeding equipment"]
[null,"Nebulizer"]
[null,"C-PAP"]
[null,"Oxygen"]
[null,"Ventilator"]
[null,"Pulse oxymeter"]
[null,"Heart monitor"]
[null,"Suctioning equipment"]
[null,"Vagus nerve stimulator (VNS)"]
[null,"Diabetic insulin pump"]
[null,"Baclofen pump"]
[null,"Prosthetics"]
["Nighttime Needs","Support Needs Category"]
[null,{"$f":"'Nighttime Needs'!A3","v":"NIGHTTIME NEEDS "}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Social Needs","Support Needs Category",null,"None"]
[null,{"$f":"'Social and Behavioral Needs'!A3","v":"COMMUNITY INTEGRATION SUPPORT"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
[null,"Support Needs Category",null,"None"]
[null,{"$f":"'Social and Behavioral Needs'!A16","v":"SOCIAL INTERACTION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
["Behavioral Needs","Support Needs Category",null,"None"]
[null,{"$f":"'Social and Behavioral Needs'!A28","v":"BEHAVIORAL SUPPORTS - NO FORMAL PLAN - SUPERVISON AND MONITORING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A41","v":"BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A55","v":"BEHAVIORAL SUPPORTS - SUPERVISON - HOME"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A69","v":"BEHAVIORAL SUPPORTS - SUPERVISION - HOME - EXCLUSIVE FOCUS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A87","v":"BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Behav. Enh./Except.","(None)"]
[null,"Behavior support plan, implementation "]
[null,"Behavior documentation data"]
[null,"Behavior support plan, multiple revisions"]
[null,"Protective physical interventions"]
[null,"Awake caregiver required 20 or more hours per day"]

{"sheet":"Summary of In-Home Hours","index":8,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[0,0,0,5],[1,1,1,2],[1,4,1,5],[2,1,2,2],[2,4,2,5],[3,0,3,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[10,4,11,5],[11,0,11,2],[12,0,12,2],[12,3,12,4],[14,0,14,2],[15,4,15,5],[16,0,17,2],[18,0,18,5],[18,6,18,11],[19,0,19,5],[20,1,20,2],[20,4,20,5],[22,0,23,0],[22,1,23,5]]}
["In Home Needs Summary - Adult"]
["Name of Individual ",{"$f":"IF(ClientName=0,\"\",ClientName)","v":""},null,"Date of Birth ",{"$f":"IF(ClientDOB=0,\"\",ClientDOB)","v":""}]
["Date of Assessment ",{"$f":"IF(AssessmentDate=0,\"\",AssessmentDate)","v":""},null,"Age ",{"$f":"ClientAge","v":""}]
[{"$nulls":3},"Assessed Hours\nPer Day","2:1 Review Required?",{"$f":"IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"\",\"Approved Monthly 2:1 Hours\")","v":""}]
[]
["ADL/IADL Hourly Supports",null,null,{"$f":"IF(ServiceSetting=ANA_GroupHome,\"N/A (SE 50 or 141)\",IF(ServiceSetting=ANA_FosterCare,\"N/A (SE 58)\",'Raw Scoring'!$K$9))","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",ADLs2to1Rev)","v":"No"},{"$f":"IF(OR(E6=\"No\",E6=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(SUM('2-1 Review and Approval'!L6:L8)>0,SUM('2-1 Review and Approval'!L6:L8),0)))","v":" "}]
["Behavior Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$10)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Behav2to1Rev)","v":"No"},{"$f":"IF(OR(E7=\"No\",E7=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(SUM('2-1 Review and Approval'!L11:L12)>0,SUM('2-1 Review and Approval'!L11:L12),0)))","v":" "}]
["Medical & Safety Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$11)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Med2to1Rev)","v":"No"},{"$f":"IF(OR(E8=\"No\",E8=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(('2-1 Review and Approval'!L9)>0,('2-1 Review and Approval'!L9),0)))","v":" "}]
["Community Access/Social Hourly Support",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$12)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Social2to1Rev)","v":"No"},{"$f":"IF(OR(E9=\"No\",E9=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",\"\"))","v":" "}]
["Nighttime Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$13)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Night2to1Rev)","v":"No"},{"$f":"IF(OR(E10=\"No\",E10=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(('2-1 Review and Approval'!L10)>0,('2-1 Review and Approval'!L10),0)))","v":" "}]
["Daily Average Attendant Care Hours",null,null,{"$f":"IF(NOT(ClientDemComplete),\"Incomplete Demographics\",IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$14))","v":"Incomplete Demographics"}]
["Monthly Attendant Care Hours",null,null,{"$f":"IF(NOT(ClientDemComplete),$D$11,IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$K$15))","v":"Incomplete Demographics"}]
["Additional Monthly Attendant Care Hours for 2:1 Support ",{"$nulls":4},{"$f":"Approved2to1HoursQualified","v":{"v":0,"d":"0 "}}]
[]
["2:1 hours included in the total shown on this line may be used ONLY for a second caregiver working during the Attendant care hours shown above, for provision of supports assessed as requiring 2 caregivers.",null,null,"Total Approved Monthly Attendant Care hours, including 2:1 hours",{"$f":"IF(NOT(ISNUMBER($D$11)),$D$11,IF(NOT(ISNUMBER($D$6)),$D$6,MonthlyCareHoursTotal))","v":"Incomplete Demographics"},{"$f":"IF(NOT(ISNUMBER($D$11)),IF(ISERR(SEARCH(\"Incomplete\",$D$11)),InterimTier,$D$11),InterimTier)","v":"Incomplete Demographics"}]
[{"$nulls":4},{"$f":"IF(AND(ISNUMBER($D$11),OR(MinLT14HrRdcnOvrrd,Min14to20HrRdcnOvrrd>0)),\"(Partial or no reduction due to minimum-hour limits)\",\"\")","v":""}]
["Enhanced/Exceptional Status",null,null,"Behavioral","Medical"]
[{"$nulls":3},{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,EE_BehavIsEnhExc)","v":"N/A"},{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,EE_MedIsEnhExc)","v":"N/A"}]
[]
["My signature verifies I have completed the In Home Support Needs Assessment using all available information\nobtained through observation, interview and the individual's records. The assessment accurately reflects the individual's\nsupport needs according to the interpretations contained in the ANA/CNA Manual."]
["Completed by:",{"$f":"IF(ISBLANK(AssessorName),\"\",AssessorName)","v":""},null,"Signature:","________________________________"]
[]
["Comments: "]
{"$rows_empty":7}
[{"$f":"EffectivePreRedn*100","v":0}]
[{"$f":"EffectivePostRedn*100","v":0}]

{"sheet":"2-1 Review and Approval","index":9,"n_rows":25,"n_cols":12,"rows_kept":25,"merged":[[1,0,1,1],[1,2,1,3],[1,5,1,6],[3,0,3,3],[3,6,3,10],[12,1,12,2],[14,0,14,3],[14,5,14,10],[15,0,15,3],[15,5,15,10],[17,0,17,3],[17,5,17,10],[18,0,18,3],[18,5,18,10],[20,0,20,3],[20,5,20,10],[22,0,22,1],[22,2,22,3],[22,5,22,7],[22,8,22,10],[24,0,24,3]]}
[]
["Review and Approval of 2 Person Supports",null,{"$f":"IF(ISBLANK('Client Demographics'!D3),\"\",'Client Demographics'!D3&\" - \"&'Client Demographics'!D4)","v":""},null,null,"DHS Review - 2:1 Exception",{"$nulls":3},"Date of Review/Determination: "]
[]
["1.  Determine the amount of 2 person hours that are necessary to safely provide the support.",{"$nulls":4},"ODDS Review Team: "]
[null,"Maximum Monthly \n2:1 Hours*","\nMonthly 2:1 Hours\nNeeded",{"$nulls":3},"\nMonthly 2:1 Hours\nApproved"]
["Mobility",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D3=\"Yes\", 30, 0))","v":0},0,null,null,"Mobility",{"$nulls":5},{"$f":"IF(G6<>0,G6,IF(ISBLANK(C6),0,MIN(B6,C6)))","v":0}]
["Transfer/Positioning",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D4=\"Yes\",30, 0))","v":0},0,null,null,"Transfer/Positioning",{"$nulls":5},0]
["Bathing",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D10=\"Yes\", 20, 0))","v":0},0,null,null,"Bathing",{"$nulls":5},0]
["Complex Medical Interventions",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(MedSupCmplx=\"Yes\", 90, 0))","v":0},0,null,null,"Complex Medical Interventions",{"$nulls":5},0]
["Night",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!J2=\"Yes\", 90, 0))","v":0},0,null,null,"Night",{"$nulls":5},0]
["Behavior - Home",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(BehavSupvsnExclFocus=\"Yes\", 90, 0))","v":0},0,null,null,"Behavior - Home",{"$nulls":5},0]
["Behavior - Community",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(BehavSupvsnCmty=\"Yes\", 30, 0))","v":0},0,null,null,"Behavior - Community",null,null," ",null,null,0]
["Locally Approved 2:1 hours",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),'Summary of In-Home Hours'!$D$6,Approved2to1Hours)","v":0},null," ",null,"ODDS Approved 2:1 hours",{"$f":"IF(NOT(ISNUMBER(Approved2to1HoursQualified)),Approved2to1HoursQualified,SUM(G6:G12))","v":0},{"$nulls":4},{"$f":"SUM(L6:L12)","v":0}]
[]
["2. Confirm that the 2:1 support assessed is necessary.  There is no means of safely performing the support with a single, qualified caregiver.  \n- The 2:1 support is needed in all or almost all cases where the activity is performed and is not a need only in specific situations.  \n- The amount authorized is based on the actual frequency and duration of the activity(ies) that require 2:1 support.  \nInclude brief comment regarding rationale for approval or non-approval, below.   ",{"$nulls":4},"2. Does the information provided support the assessment that 2:1 support is necessary in the categories recorded?"]
[]
[]
["3.  Confirm that the individual's file includes documentation that supports the need for the 2:1 support by identifying the type of documentation, below.  If 2:1 is support is not approved, enter \"N/A\".    (Examples:  Physical Therapy evaluation dated 2/5/11, Physician's note dated 3/8/12, Case note 1/12/13 re: Service Coordinator's observation.) ",{"$nulls":4},"3.  Support tasks, reported frequency, usual duration of 2:1 need:"]
[]
[{"$nulls":5},"Additional Information:"]
["4. Authorized Signature.   Review and approval may only be completed by the Brokerage Director or CDDP Manager  or  their designee.   The Personal Agent or Services Coordinator may not authorize 2:1 support for an individual on their caseload.  \nTo complete the electronic file, the authorized signer enters their name and the date into the boxes, below.   A copy of this page retained in the client file."]
["SIGNATURE",null,"DATE",null,null,"ODDS SIGNATURE",null,null,"DATE"]
[]
[]
["*\"Maximum Monthly 2:1 Hours\" are the highest allocations of 2:1 support which may be authorized by a CDDP or Support Services Brokerage.   When support is needed in excess of the amounts shown above, an Exception Request may be submitted to ODDS for review.  \nFax a copy of this completed worksheet to:   503-373-7274, ATTN: In-Home 2:1 Exception Request"]

{"sheet":"Raw Scoring","index":10,"n_rows":45,"n_cols":40,"rows_kept":45,"hidden":true,"merged":[[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,7,17,9]]}
["ADL\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","Hours","Nighttime\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","Hours","Medical\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","Hours","Social\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","Hours","Behavior\nGroup ID","Selection\nValue","Behavior\nDuplication\nAdjustments","Adjusted\nValue","2:1 Review","New\nScoring\nRow","Hours",null,"EE_Nursing\nGroup ID","Selection\nValue",null,"EE_Behav\nGroup ID","Selection\nValue"]
["ADL1",0,{"$f":"B2","v":0},"N/A",{"$f":"MATCH(A2,'New Scoring'!$A:$A,0)+C2","v":3},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,E2-1,IF(D2=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},"Nighttime1",0,{"$f":"H2","v":0},"No",{"$f":"MATCH(G2,'New Scoring'!$A:$A,0)+I2","v":75},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,K2-1,IF(J2=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},"Medical1",0,{"$f":"N2","v":0},"N/A",{"$f":"MATCH(M2,'New Scoring'!$A:$A,0)+O2","v":81},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,Q2-1,IF(P2=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},"Social1",0,{"$f":"T2","v":0},"N/A",{"$f":"MATCH(S2,'New Scoring'!$A:$A,0)+U2","v":209},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,W2-1,Default_NS_AgeCol-1,1,1))","v":{"v":0,"d":"0.00"}},"Behavior1",0,null,{"$f":"(IF((AB4+AB5)>1,0,Z2))","v":0},"N/A",{"$f":"MATCH(Y2,'New Scoring'!$A:$A,0)+AB2","v":183},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,AD2-1,IF(AC2=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},null,"Ventilator1",0,null,"SupPlanImpl1",0,null,"EE_MedIsEnh:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingEnh,$AN$9,$AN$11),IF(MedShEnh,$AN$12,$AN$11))","v":"N/A"}]
["ADL2",0,{"$f":"B3","v":0},"No",{"$f":"MATCH(A3,'New Scoring'!$A:$A,0)+C3","v":9},{"v":0,"d":"0.00"},"Totals",{"$f":"SUM(H2:H2)","v":0},{"$f":"MAX(I2:I2)","v":0},{"$f":"IF(COUNTIF(J1:J2,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,{"$f":"SUM(L2:L2)","v":{"v":0,"d":"0.00"}},"Medical2",0,{"$f":"N3","v":0},"N/A",{"$f":"MATCH(M3,'New Scoring'!$A:$A,0)+O3","v":87},{"v":0,"d":"0.00"},"Social2",0,{"$f":"T3","v":0},"N/A",{"$f":"MATCH(S3,'New Scoring'!$A:$A,0)+U3","v":215},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,W3-1,Default_NS_AgeCol-1,1,1))","v":{"v":0,"d":"0.00"}},"Behavior2",0,null,{"$f":"Z3","v":0},"N/A",{"$f":"MATCH(Y3,'New Scoring'!$A:$A,0)+AB3","v":189},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,AD3-1,IF(AC3=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},null,"CPAP2",0,null,"SupPlanRevised2",0,null,"EE_MedIsExc:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingExc,$AN$10,$AN$11),IF(OR(MedShEnh,MedShExc),$AN$12,$AN$11))","v":"N/A"}]
["ADL3",0,0,"No",{"$f":"MATCH(A4,'New Scoring'!$A:$A,0)+C4","v":15},{"v":0,"d":"0.00"},{"$nulls":6},"Medical3",0,0,"N/A",{"$f":"MATCH(M4,'New Scoring'!$A:$A,0)+O4","v":93},{"v":0,"d":"0.00"},"Social3",0,{"$f":"T4","v":0},"No",{"$f":"MATCH(S4,'New Scoring'!$A:$A,0)+U4","v":221},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,W4-1,Default_NS_AgeCol-1,1,1))","v":{"v":0,"d":"0.00"}},"Behavior3",0,{"$f":"Z2+Z4","v":0},{"$f":"IF(AA4 = 4,2,IF(AA4>4,3,Z4))","v":0},"N/A",{"$f":"MATCH(Y4,'New Scoring'!$A:$A,0)+AB4","v":195},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,AD4-1,IF(AC4=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},null,"Oxygen3",0,null,"CmplxTools3",0,null,"EE_MedIsEnhExc:",{"$f":"IF(EE_MedIsExc<>$AN$11,EE_MedIsExc,EE_MedIsEnh)","v":"N/A"}]
["ADL4",0,0,"N/A",{"$f":"MATCH(A5,'New Scoring'!$A:$A,0)+C5","v":21},{"v":0,"d":"0.00"},{"$nulls":6},"Medical4",0,0,"N/A",{"$f":"MATCH(M5,'New Scoring'!$A:$A,0)+O5","v":99},{"v":0,"d":"0.00"},"Totals",{"$f":"SUM(T2:T4)","v":0},{"$f":"SUM(U2:U4)","v":0},{"$f":"IF(COUNTIF(V1:V4,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,{"$f":"SUM(X2:X4)","v":{"v":0,"d":"0.00"}},"Behavior4",0,null,{"$f":"Z5","v":0},"No",{"$f":"MATCH(Y5,'New Scoring'!$A:$A,0)+AB5","v":201},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,AD5-1,IF(AC5=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},null,"Resp4",0,null,"PPI4",0,null,"EE_BehavIsEnh:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavEnh,$AN$9,$AN$11),IF(BehavShEnh,$AN$12,$AN$11))","v":"N/A"}]
["ADL5",0,0,"N/A",{"$f":"MATCH(A6,'New Scoring'!$A:$A,0)+C6","v":27},{"v":0,"d":"0.00"},{"$nulls":6},"Medical5",0,0,"N/A",{"$f":"MATCH(M6,'New Scoring'!$A:$A,0)+O6","v":105},{"v":0,"d":"0.00"},{"$nulls":6},"Totals",{"$f":"SUM(Z2:Z5)","v":0},null,{"$f":"SUM(AB2:AB5)","v":0},{"$f":"IF(COUNTIF(AC1:AC5,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,{"$f":"SUM(AE2:AE5)","v":{"v":0,"d":"0.00"}},null,"Trach5",0,null,"TwentyHrs5",0,null,"EE_BehavIsExc:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavExc,$AN$10,$AN$11),IF(OR(BehavShEnh,BehavShExc),$AN$12,$AN$11))","v":"N/A"}]
["ADL6",0,0,"N/A",{"$f":"MATCH(A7,'New Scoring'!$A:$A,0)+C7","v":33},{"v":0,"d":"0.00"},{"$nulls":6},"Medical6",0,0,"N/A",{"$f":"MATCH(M7,'New Scoring'!$A:$A,0)+O7","v":111},{"v":0,"d":"0.00"},{"$nulls":6},"Enhanced",{"$f":"AND(Z3 >= 1, Z4 >= 2, T4 >= 3)","v":false},{"$nulls":6},"Suction6",0,null,"None6",0,null,"EE_BehavIsEnhExc:",{"$f":"IF(EE_BehavIsExc<>$AN$11,EE_BehavIsExc,EE_BehavIsEnh)","v":"N/A"}]
["ADL7",0,0,"N/A",{"$f":"MATCH(A8,'New Scoring'!$A:$A,0)+C8","v":39},{"v":0,"d":"0.00"},"(Moved Bladder/Bowel vs. Toileting override to enable/disable functionality)",{"$nulls":5},"Medical7",0,0,"N/A",{"$f":"MATCH(M8,'New Scoring'!$A:$A,0)+O8","v":117},{"v":0,"d":"0.00"},{"$nulls":6},"Exceptional",{"$f":"AND(Z3 >= 2, Z4 >= 3, T4 >= 4)","v":false},{"$nulls":6},"Stoma7",0,null,"Total",{"$f":"SUM(AK2:AK5)","v":0}]
["ADL8",0,0,"N/A",{"$f":"MATCH(A9,'New Scoring'!$A:$A,0)+C9","v":45},{"v":0,"d":"0.00"},null,"ADL/IADL Hourly Supports",null,null,{"$f":"IF($K$21>$G$26,$K$21-($K$10+$K$11+$K$13),$B$26)","v":0},null,"Medical8",0,0,"N/A",{"$f":"MATCH(M9,'New Scoring'!$A:$A,0)+O9","v":123},{"v":0,"d":"0.00"},{"$nulls":14},"FeedingTube8",0,null,"Enhanced",{"$f":"AK2>0","v":false},null,"Text:","Enhanced"]
["ADL9",0,0,"No",{"$f":"MATCH(A10,'New Scoring'!$A:$A,0)+C10","v":51},{"v":0,"d":"0.00"},null,"Behavior Hourly Supports",null,null,{"$f":"$E$26","v":0},null,"Medical9",0,0,"No",{"$f":"MATCH(M10,'New Scoring'!$A:$A,0)+O10","v":129},{"v":0,"d":"0.00"},{"$nulls":14},"Diabetes9",0,null,"Exceptional",{"$f":"AND(EE_BehavEnh,AK6,SUM(AK3:AK5)>0)","v":false},null,null,"Exceptional"]
["ADL10",0,0,"N/A",{"$f":"MATCH(A11,'New Scoring'!$A:$A,0)+C11","v":57},{"v":0,"d":"0.00"},null,"Medical & Safety Hourly Supports",null,null,{"$f":"$D$26","v":0},null,"Medical10",null,null,"N/A",{"$f":"MATCH(M11,'New Scoring'!$A:$A,0)+O11","v":135},null,"(Old, unused \"Nursing\" section removed!)",{"$nulls":13},"Injection10",0,null,"Complete",{"$f":"OR(AK6,AK7, AK8>0)","v":false},null,null,"N/A"]
["ADL11",0,0,"N/A",{"$f":"MATCH(A12,'New Scoring'!$A:$A,0)+C12","v":63},{"v":0,"d":"0.00"},null,"Community Access/Social Hourly Support",null,null,{"$f":"$F$26","v":0},null,"Medical11",0,{"$f":"N12","v":0},"N/A",{"$f":"MATCH(M12,'New Scoring'!$A:$A,0)+O12","v":141},{"$f":"IF(ScoringAge=0,0,OFFSET(NS_Values,Q12-1,IF(P12=\"Yes\",Unreduced_NS_AgeCol,Default_NS_AgeCol)-1,1,1))","v":{"v":0,"d":"0.00"}},{"$nulls":14},"Dialysis11",0,{"$nulls":5},"Please fill out \"Enhanced or Exception\" sheet"]
["ADL12",0,0,"N/A",{"$f":"MATCH(A13,'New Scoring'!$A:$A,0)+C13","v":69},{"v":0,"d":"0.00"},null,"Nighttime Hourly Supports",null,null,{"$f":"$C$26","v":0},null,"Medical12",0,{"$f":"N13","v":0},"N/A",{"$f":"MATCH(M13,'New Scoring'!$A:$A,0)+O13","v":147},{"v":0,"d":"0.00"},{"$nulls":14},"Shunt12",0]
["Totals",{"$f":"SUM(B2:B13)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"IF(COUNTIF(D1:D13,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,{"$f":"SUM(F2:F13)","v":{"v":0,"d":"0.00"}},null,"Daily Average Attendant Care Hours",null,null,{"$f":"SUM($K$9:$K$13)","v":0},null,"Medical13",0,0,"N/A",{"$f":"MATCH(M14,'New Scoring'!$A:$A,0)+O14","v":153},{"v":0,"d":"0.00"},{"$nulls":14},"VitalSigns13",0]
[{"$nulls":7},"Monthly Attendant Care Hours",null,null,{"$f":"ROUNDUP($K$14*DaysPerMo,0)","v":0},null,"Medical14",0,0,"N/A",{"$f":"MATCH(M15,'New Scoring'!$A:$A,0)+O15","v":159},{"v":0,"d":"0.00"},{"$nulls":14},"Seisure14",0]
[{"$nulls":7},"< 14 hr Min. Score Reduction Override",null,null,false,"Set by VBA","Medical15",0,0,"N/A",{"$f":"MATCH(M16,'New Scoring'!$A:$A,0)+O16","v":165},{"v":0,"d":"0.00"},{"$nulls":14},"MedPump15",0]
[{"$nulls":7},"14 to 20 hr Min. Score Reduction Override",null,null,0,"code1,2","Medical16",0,0,"N/A",{"$f":"MATCH(M17,'New Scoring'!$A:$A,0)+O17","v":171},{"v":0,"d":"0.00"},{"$nulls":14},"WoundCare16",0]
[{"$nulls":7},"Monthly + 2:1 Hrs.",null,null,{"$f":"IF(Min14to20HrRdcnOvrrd>0,Min14to20HrRdcnOvrrd,$K$15+Approved2to1Hours)","v":0},null,"Medical17",0,0,"N/A",{"$f":"MATCH(M18,'New Scoring'!$A:$A,0)+O18","v":177},{"v":0,"d":"0.00"},{"$nulls":14},"SumpCare17",0]
[{"$nulls":12},"Totals",{"$f":"SUM(N2:N18)","v":0},{"$f":"SUM(O2:O18)","v":0},{"$f":"IF(COUNTIF(P1:P18,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,{"$f":"SUM(R2:R18)","v":{"v":0,"d":"0.00"}},{"$nulls":14},"Ostomy18",0]
[null,"ADL","Nighttime","Medical","Behavior","SocComm","Total","DayTime Total",null,"Personal Care Minimum",{"$f":"20/DaysPerMo","v":{"v":0.6576783952647155,"d":"0.66"}},null,"Enhanced",{"$f":"OR(N10 >= 1, AND(N9 >= 2, OR(N7 >= 2, N8 >= 3, N18 >= 2, B5 >= 4)))","v":false},{"$nulls":18},"ImpactionCare19",0]
["Hours",{"$f":"F14","v":{"v":0,"d":"0.00"}},{"$f":"L3","v":{"v":0,"d":"0.00"}},{"$f":"R19","v":{"v":0,"d":"0.00"}},{"$f":"AE6","v":{"v":0,"d":"0.00"}},{"$f":"X5","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B21:F21)","v":{"v":0,"d":"0.00"}},{"$f":"B21+D21+E21+F21","v":{"v":0,"d":"0.00"}},null,"Pers Care Applicability",{"$f":"IF(F3+F4+F5+F7+F10+F11>0,K20,0)","v":{"v":0,"d":"0.00"}},null,"Exceptional",{"$f":"AND(MedShEnh, N11 >= 2)","v":false},{"$nulls":18},"Cath20",0]
["Hours Adjusted 1",{"$f":"IF((D21+E21)>11, IF(B21>5, 5, B21), IF(B21>6,6,B21))","v":{"v":0,"d":"0.00"}},{"$f":"IF(C21>7,7,C21)","v":{"v":0,"d":"0.00"}},{"$f":"IF((E21+F21)>8, IF(D21>7, 7, D21), IF(D21>12,12,D21))","v":{"v":0,"d":"0.00"}},{"$f":"IF((D21+F21)>8, IF(E21>7, 7, E21), IF(E21>10,10,E21))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F21>3.2,3.2,F21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"B22+D22+E22+F22","v":{"v":0,"d":"0.00"}},{"$nulls":24},"Positioning21",0]
["Hours Adjusted 2",{"$f":"B22","v":{"v":0,"d":"0.00"}},{"$f":"IF((C22/7)>(H23/17),((H23/17)*7),C22)","v":{"v":0,"d":"0.00"}},{"$f":"D22","v":{"v":0,"d":"0.00"}},{"$f":"E22","v":{"v":0,"d":"0.00"}},{"$f":"F22","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"B23+D23+E23+F23","v":{"v":0,"d":"0.00"}},{"$nulls":3},"1For reduced scores < 14 hrs/mo (equiv. to < 20 hrs in version-C), the final, displayed score should be same as version-C score (i.e.  unreduced).",{"$nulls":20},"TwentyHrs22",0]
["Hours Adjusted 3",{"$f":"IF($H$23>17,(B23/$H$23)*17,B23)","v":{"v":0,"d":"0.00"}},{"$f":"C23","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(D23/$H$23)*17,D23)","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(E23/$H$23)*17,E23)","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(F23/$H$23)*17,F23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"B24+D24+E24+F24","v":{"v":0,"d":"0.00"}},{"$nulls":3},"2For reduced scores between 14-20 hrs/mo (equiv. to 20-28.57 hrs in version-C),  the final, displayed score should be a minimum of 20 hrs/mo.",{"$nulls":20},"None23",0]
["Hours Adjusted 4",{"$f":"IF($G$24>24,(B24/$G$24)*24,B24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(C24/$G$24)*24,C24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(D24/$G$24)*24,D24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(E24/$G$24)*24,E24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(F24/$G$24)*24,F24)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$nulls":4},"(see the CheckMinScoringValues routine)",{"$nulls":20},"Total",{"$f":"SUM(AH2:AH22)","v":0}]
["Hours Adjusted 5",{"$f":"B25-(B25*$E$32)","v":{"v":0,"d":"0.00"}},{"$f":"C25-(C25*$E$32)","v":{"v":0,"d":"0.00"}},{"$f":"D25-(D25*$E$32)","v":{"v":0,"d":"0.00"}},{"$f":"E25-(E25*$E$32)","v":{"v":0,"d":"0.00"}},{"$f":"F25-(F25*$E$32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$nulls":25},"Enhanced",{"$f":"AH25>=2","v":false}]
["Adult Rate",{"$nulls":6},"(Obsolete SNAP)",{"$nulls":24},"Exceptional",{"$f":"AND(AH25>=4,AH23)","v":false}]
["Kid Rate",{"$nulls":6},"(Obsolete SNAP)",{"$nulls":24},"Complete",{"$f":"OR(AH23,AH24, AH25>0)","v":false}]
["Days",{"$nulls":6},"(Obsolete SNAP)"]
["Total Adult",{"$nulls":6},"(Obsolete SNAP)"]
["Total Kid",{"$nulls":6},"(Obsolete SNAP)"]
[null,null,"Post-Reduction:",{"v":0,"d":"0%"},{"$f":"IF(OR(ServiceElement=SE51SelectionStr,MinLT14HrRdcnOvrrd),0,$D$32)","v":{"v":0,"d":"0%"}}]
[]
["Age LookUp","New Scoring","Unreduced Scoring",null,null,"Interim Tier Monthly Total ",{"$f":"DaysPerMo*ScoreTotalHours","v":{"v":0,"d":"0.00"}},"Set by VBA code (see the SetInterimTierScore routine)"]
["(Year.Fraction)","Age Column","Age Column",null,null,"2-to-1 Locally Approved Total ",{"$f":"Approved2to1Hours","v":{"v":0,"d":"0.00"}},"Note: 2-to-1 hours are unreduced, so this works as-is"]
[{"$f":"IF(ClientDOB=\"\",\n       \"\",\n       IF(DATEDIF(ClientDOB,AssessmentDate,\"Y\")=0,\n            ROUND(DATEDIF(ClientDOB,AssessmentDate,\"YM\")/12, 1),\n            IF(DATEDIF(ClientDOB,AssessmentDate,\"Y\")=1,\n                 ROUND(DATEDIF(ClientDOB,AssessmentDate,\"M\")/12, 1),\n                 DATEDIF(ClientDOB,AssessmentDate,\"Y\"))))","v":""},{"$f":"COLUMN(NS_AgeGE18)","v":11},{"$f":"COLUMN(UR_AgeGE18)","v":24},null,null,"Total ",{"$f":"G34+G35","v":{"v":0,"d":"0.00"}}]
[]
[" Avg. Days/Month",{"$nulls":4},0,"Interim Tier 1"]
[30.41,{"$nulls":4},160.01,"Interim Tier 2"]
[{"$nulls":5},275.01,"Interim Tier 3"]
[{"$nulls":5},390.01,"Interim Tier 4"]
[{"$nulls":5},510.01,"Interim Tier 5"]
[{"$nulls":5},630.01,"Interim Tier 6"]
[]
[{"$nulls":5},"Interim Tier:",{"$f":"VLOOKUP($G$36,TierTable,2,TRUE)","v":"Interim Tier 1"}]

{"sheet":"New Scoring","index":11,"n_rows":226,"n_cols":29,"rows_kept":226,"hidden":true,"merged":[[0,2,0,10],[0,15,0,23]]}
["Pre-Reduction:",{"v":0,"d":"0%"},"ANA - NEW BREAKPOINTS (Same scores)",{"$nulls":8},{"$f":"IF(OR(ServiceElement=SE51SelectionStr,MinLT14HrRdcnOvrrd),0,$B$1)","v":{"v":0,"d":"0%"}},{"$nulls":3},"ANA - NEW BREAKPOINTS (Same scores)",{"$nulls":10},"Values Last updated"]
["Category","Selection\nValue","0-2",3,4,5,"6-9","10-11","12-14","15-17","18+","Hours per\nMonth","Topic","NOTE: Blue font items are formulas!",null,"0-2",3,4,5,"6-9","10-11","12-14","15-17","18+","Hours per\nDay plus...","Minutes\nper Day","2016-04-19","Score\nRange Names","Unreduced\nRange Names"]
["ADL1",0,{"$f":"P3-(P3*$L$1)","v":0},{"$f":"Q3-(Q3*$L$1)","v":0},{"$f":"R3-(R3*$L$1)","v":0},{"$f":"S3-(S3*$L$1)","v":0},{"$f":"T3-(T3*$L$1)","v":0},{"$f":"U3-(U3*$L$1)","v":0},{"$f":"V3-(V3*$L$1)","v":0},{"$f":"W3-(W3*$L$1)","v":0},{"$f":"X3-(X3*$L$1)","v":0},{"$f":"K3*DaysPerMo","v":0},"Transportation",null,null,0,0,0,0,0,0,0,null,{"$f":"$Y3+$Z3/60","v":0},null,0,null,"NS_Age0to2","UR_Age0to2"]
["ADL1",1,0,0,0,0,0,0,0,0,{"v":0.03285,"d":"0.033"},{"v":0.9989684999999999,"d":"1.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03285,"d":"0.033"},null,{"v":1.9709999999999999,"d":"1.97"},"(Fractions are derived from","NS_Age3","UR_Age3"]
["ADL1",2,0,0,0,0,0,0,0,0,{"v":0.03285,"d":"0.033"},{"v":0.9989684999999999,"d":"1.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03285,"d":"0.033"},null,{"v":1.9709999999999999,"d":"1.97"},"original, version-A values)","NS_Age4","UR_Age4"]
["ADL1",3,0,0,0,0,0,0,0,0,{"v":0.0657,"d":"0.066"},{"v":1.9979369999999999,"d":"2.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.0657,"d":"0.066"},null,{"v":3.9419999999999997,"d":"3.94"},null,"NS_Age5","UR_Age5"]
["ADL1",4,0,0,0,0,0,0,0,0,{"v":0.0657,"d":"0.066"},{"v":1.9979369999999999,"d":"2.00"}," ",null,null,0,0,0,0,0,0,0,null,{"v":0.0657,"d":"0.066"},null,{"v":3.9419999999999997,"d":"3.94"},null,"NS_Age6to9","UR_Age6to9"]
["ADL1",5,0,0,0,0,0,0,0,0,{"v":0.0657,"d":"0.066"},{"v":1.9979369999999999,"d":"2.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.0657,"d":"0.066"},null,{"v":3.9419999999999997,"d":"3.94"},null,"NS_Age10to11","UR_Age10to11"]
["ADL2",0,0,0,0,0,0,0,0,0,0,0,"Ambulation/Mobility",null,null,0,0,0,0,0,0,0,null,0,null,0,null,"NS_Age12to14","UR_Age12to14"]
["ADL2",1,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30,null,"NS_Age15to17","UR_Age15to17"]
["ADL2",2,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30,null,"NS_AgeGE18","UR_AgeGE18"]
["ADL2",3,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL2",4,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["ADL2",5,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["ADL3",0,0,0,0,0,0,0,0,0,0,0,"Transferring/Positioning",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL3",1,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["ADL3",2,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["ADL3",3,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["ADL3",4,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,1,15]
["ADL3",5,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,1,15]
["ADL4",0,0,0,0,0,0,0,0,0,0,0,"Eating/Drinking",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL4",1,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL4",2,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},1,0]
["ADL4",3,0,0,0,0,0,0,0,0,{"v":1.3333333333333333,"d":"1.333"},{"v":40.54666666666667,"d":"40.55"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.3333333333333333,"d":"1.333"},1,20]
["ADL4",4,0,0,0,0,0,0,0,0,1.75,{"v":53.2175,"d":"53.22"},{"$nulls":3},0,0,0,0,0,0,0,null,1.75,1,45]
["ADL4",5,0,0,0,0,0,0,0,0,1.75,{"v":53.2175,"d":"53.22"},{"$nulls":3},0,0,0,0,0,0,0,null,1.75,1,45]
["ADL5",0,0,0,0,0,0,0,0,0,0,0,"Meal Preparation",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL5",1,0,0,0,0,0,0,0,0,{"v":0.13333333333333333,"d":"0.133"},{"v":4.054666666666667,"d":"4.05"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.13333333333333333,"d":"0.133"},null,8]
["ADL5",2,0,0,0,0,0,0,0,0,{"v":0.2,"d":"0.20"},{"v":6.082000000000001,"d":"6.08"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.2,"d":"0.20"},null,12]
["ADL5",3,0,0,0,0,0,0,0,0,{"v":0.3333333333333333,"d":"0.333"},{"v":10.136666666666667,"d":"10.14"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.3333333333333333,"d":"0.333"},null,20]
["ADL5",4,0,0,0,0,0,0,0,0,{"v":0.3333333333333333,"d":"0.333"},{"v":10.136666666666667,"d":"10.14"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.3333333333333333,"d":"0.333"},null,20]
["ADL5",5,0,0,0,0,0,0,0,0,{"v":0.3333333333333333,"d":"0.333"},{"v":10.136666666666667,"d":"10.14"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.3333333333333333,"d":"0.333"},null,20]
["ADL6",0,0,0,0,0,0,0,0,0,0,0,"Bladder/Bowel",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL6",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL6",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL6",3,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL6",4,0,0,0,0,0,0,0,0,{"v":1.3333333333333333,"d":"1.333"},{"v":40.54666666666667,"d":"40.55"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.3333333333333333,"d":"1.333"},1,20]
["ADL6",5,0,0,0,0,0,0,0,0,{"v":1.3333333333333333,"d":"1.333"},{"v":40.54666666666667,"d":"40.55"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.3333333333333333,"d":"1.333"},1,20]
["ADL7",0,0,0,0,0,0,0,0,0,0,0,"Toileting",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL7",1,0,0,0,0,0,0,0,0,{"v":0.1,"d":"0.10"},{"v":3.0410000000000004,"d":"3.04"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1,"d":"0.10"},null,6]
["ADL7",2,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL7",3,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["ADL7",4,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["ADL7",5,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["ADL8",0,0,0,0,0,0,0,0,0,0,0,"Laundry/Housekeeping",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL8",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL8",2,0,0,0,0,0,0,0,0,0.05,{"v":1.5205000000000002,"d":"1.52"},{"$nulls":3},0,0,0,0,0,0,0,null,0.05,null,3]
["ADL8",3,0,0,0,0,0,0,0,0,{"v":0.08333333333333333,"d":"0.083"},{"v":2.5341666666666667,"d":"2.53"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08333333333333333,"d":"0.083"},null,5]
["ADL8",4,0,0,0,0,0,0,0,0,{"v":0.16666666666666666,"d":"0.167"},{"v":5.068333333333333,"d":"5.07"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.16666666666666666,"d":"0.167"},null,10]
["ADL8",5,0,0,0,0,0,0,0,0,{"v":0.16666666666666666,"d":"0.167"},{"v":5.068333333333333,"d":"5.07"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.16666666666666666,"d":"0.167"},null,10]
["ADL9",0,0,0,0,0,0,0,0,0,0,0,"Bathing",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL9",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL9",2,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["ADL9",3,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["ADL9",4,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["ADL9",5,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["ADL10",0,0,0,0,0,0,0,0,0,0,0,"Hygiene",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL10",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL10",2,0,0,0,0,0,0,0,0,0.125,{"v":3.80125,"d":"3.80"},{"$nulls":3},0,0,0,0,0,0,0,null,0.125,null,{"v":7.5,"d":"8"}]
["ADL10",3,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["ADL10",4,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["ADL10",5,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["ADL11",0,0,0,0,0,0,0,0,0,0,0,"Dressing/Hair Care",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL11",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["ADL11",2,0,0,0,0,0,0,0,0,{"v":0.16699999999999998,"d":"0.167"},{"v":5.078469999999999,"d":"5.08"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.16699999999999998,"d":"0.167"},null,{"v":10.02,"d":"10"}]
["ADL11",3,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL11",4,{"$f":"P67-(P67*$L$1)","v":0},{"$f":"Q67-(Q67*$L$1)","v":0},{"$f":"R67-(R67*$L$1)","v":0},{"$f":"S67-(S67*$L$1)","v":0},{"$f":"T67-(T67*$L$1)","v":0},{"$f":"U67-(U67*$L$1)","v":0},{"$f":"V67-(V67*$L$1)","v":0},{"$f":"W67-(W67*$L$1)","v":0},{"$f":"X67-(X67*$L$1)","v":{"v":0.5,"d":"0.50"}},{"$f":"K67*DaysPerMo","v":{"v":15.205,"d":"15.21"}},{"$nulls":3},0,0,0,0,0,0,0,null,{"$f":"$Y67+$Z67/60","v":{"v":0.5,"d":"0.50"}},null,30]
["ADL11",5,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["ADL12",0,0,0,0,0,0,0,0,0,0,0,"Shopping/Money Mgmt.",null,null,0,0,0,0,0,0,0,null,0,null,0]
["ADL12",1,0,0,0,0,0,0,0,0,{"v":0.03333333333333333,"d":"0.033"},{"v":1.0136666666666667,"d":"1.01"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03333333333333333,"d":"0.033"},null,2]
["ADL12",2,0,0,0,0,0,0,0,0,{"v":0.08333333333333333,"d":"0.083"},{"v":2.5341666666666667,"d":"2.53"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08333333333333333,"d":"0.083"},null,5]
["ADL12",3,0,0,0,0,0,0,0,0,{"v":0.08333333333333333,"d":"0.083"},{"v":2.5341666666666667,"d":"2.53"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08333333333333333,"d":"0.083"},null,5]
["ADL12",4,0,0,0,0,0,0,0,0,{"v":0.08333333333333333,"d":"0.083"},{"v":2.5341666666666667,"d":"2.53"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08333333333333333,"d":"0.083"},null,5]
["ADL12",5,0,0,0,0,0,0,0,0,{"v":0.08333333333333333,"d":"0.083"},{"v":2.5341666666666667,"d":"2.53"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08333333333333333,"d":"0.083"},null,5]
["Nighttime1",0,0,0,0,0,0,0,0,0,0,0,"Nighttime",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Nighttime1",1,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["Nighttime1",2,0,0,0,0,0,0,0,0,{"v":3,"d":"3.00"},91.23,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":3,"d":"3.00"},null,180]
["Nighttime1",3,0,0,0,0,0,0,0,0,{"v":6,"d":"6.00"},182.46,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":6,"d":"6.00"},null,360]
["Nighttime1",4,0,0,0,0,0,0,0,0,{"v":7,"d":"7.00"},212.87,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":7,"d":"7.00"},null,420]
["Nighttime1",5,0,0,0,0,0,0,0,0,{"v":7,"d":"7.00"},212.87,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":7,"d":"7.00"},null,420]
["Medical1",0,0,0,0,0,0,0,0,0,0,0,"Commun., Expressive & Receptive",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical1",1,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Medical1",2,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["Medical1",3,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["Medical1",4,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["Medical1",5,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["Medical2",0,0,0,0,0,0,0,0,0,0,0,"Telephone, etc.",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical2",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical2",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical2",3,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical2",4,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical2",5,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical3",0,0,0,0,0,0,0,0,0,0,0,"Safety",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical3",1,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical3",2,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,null,75]
["Medical3",3,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,null,75]
["Medical3",4,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,null,75]
["Medical3",5,0,0,0,0,0,0,0,0,1.25,{"v":38.0125,"d":"38.01"},{"$nulls":3},0,0,0,0,0,0,0,null,1.25,null,75]
["Medical4",0,0,0,0,0,0,0,0,0,0,0,"Fire Evacuation",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical4",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical4",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical4",3,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical4",4,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical4",5,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical5",0,0,0,0,0,0,0,0,0,0,0,"Medication - Oral",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical5",1,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Medical5",2,0,0,0,0,0,0,0,0,{"v":0.4166666666666667,"d":"0.417"},{"v":12.670833333333334,"d":"12.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.4166666666666667,"d":"0.417"},null,25]
["Medical5",3,0,0,0,0,0,0,0,0,{"v":0.6666666666666666,"d":"0.667"},{"v":20.273333333333333,"d":"20.27"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.6666666666666666,"d":"0.667"},null,40]
["Medical5",4,0,0,0,0,0,0,0,0,{"v":0.6666666666666666,"d":"0.667"},{"v":20.273333333333333,"d":"20.27"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.6666666666666666,"d":"0.667"},null,40]
["Medical5",5,0,0,0,0,0,0,0,0,{"v":0.6666666666666666,"d":"0.667"},{"v":20.273333333333333,"d":"20.27"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.6666666666666666,"d":"0.667"},null,40]
["Medical6",0,0,0,0,0,0,0,0,0,0,0,"Meds - Inhalants, Topicals, Supp.",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical6",1,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Medical6",2,0,0,0,0,0,0,0,0,{"v":0.4166666666666667,"d":"0.417"},{"v":12.670833333333334,"d":"12.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.4166666666666667,"d":"0.417"},null,25]
["Medical6",3,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical6",4,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical6",5,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical7",0,0,0,0,0,0,0,0,0,0,0,"Meds - Injections",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical7",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical7",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical7",3,0,0,0,0,0,0,0,0,{"v":0.33399999999999996,"d":"0.334"},{"v":10.156939999999999,"d":"10.16"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.33399999999999996,"d":"0.334"},null,{"v":20.04,"d":"20"}]
["Medical7",4,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical7",5,0,0,0,0,0,0,0,0,{"v":0.5,"d":"0.50"},{"v":15.205,"d":"15.21"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.5,"d":"0.50"},null,30]
["Medical8",0,0,0,0,0,0,0,0,0,0,0,"Health Supports - General",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical8",1,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Medical8",2,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["Medical8",3,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["Medical8",4,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["Medical8",5,0,0,0,0,0,0,0,0,{"v":1,"d":"1.00"},30.41,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1,"d":"1.00"},null,60]
["Medical9",0,0,0,0,0,0,0,0,0,0,0,"Complex Health Supports",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical9",1,0,0,0,0,0,0,0,0,0.75,{"v":22.8075,"d":"22.81"},{"$nulls":3},0,0,0,0,0,0,0,null,0.75,null,45]
["Medical9",2,{"$f":"P131-(P131*$L$1)","v":0},{"$f":"Q131-(Q131*$L$1)","v":0},{"$f":"R131-(R131*$L$1)","v":0},{"$f":"S131-(S131*$L$1)","v":0},{"$f":"T131-(T131*$L$1)","v":0},{"$f":"U131-(U131*$L$1)","v":0},{"$f":"V131-(V131*$L$1)","v":0},{"$f":"W131-(W131*$L$1)","v":0},{"$f":"X131-(X131*$L$1)","v":{"v":1.5,"d":"1.50"}},{"$f":"K131*DaysPerMo","v":{"v":45.615,"d":"45.62"}},{"$nulls":3},0,0,0,0,0,0,0,null,{"$f":"$Y131+$Z131/60","v":{"v":1.5,"d":"1.50"}},null,90]
["Medical9",3,0,0,0,0,0,0,0,0,{"v":2.5,"d":"2.50"},{"v":76.025,"d":"76.03"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":2.5,"d":"2.50"},2,30]
["Medical9",4,0,0,0,0,0,0,0,0,{"v":8,"d":"8.00"},243.28,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":8,"d":"8.00"},null,480]
["Medical9",5,0,0,0,0,0,0,0,0,{"v":8,"d":"8.00"},243.28,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":8,"d":"8.00"},null,480]
["Medical10",0,0,0,0,0,0,0,0,0,0,0,"(Unused \"Nursing\" section removed!)",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Medical10",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical10",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical10",3,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical10",4,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical10",5,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical11",0,0,0,0,0,0,0,0,0,0,0,"Equipment","Equip.: Does score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical11",1,0,0,0,0,0,0,0,0,0.035,{"v":1.0643500000000001,"d":"1.06"},{"$nulls":3},0,0,0,0,0,0,0,null,0.035,null,{"v":2.1,"d":"2"}]
["Medical11",2,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical11",3,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical11",4,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical11",5,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical12",0,0,0,0,0,0,0,0,0,0,0,null,"Equip.: No score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical12",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical12",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical12",3,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical12",4,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical12",5,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",0,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",3,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",4,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical13",5,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical14",0,0,0,0,0,0,0,0,0,0,0,null,"Equip.: No score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical14",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical14",2,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},null,"Equip.: Does score…",null,0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical14",3,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical14",4,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical14",5,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical15",0,0,0,0,0,0,0,0,0,0,0,null,"Equip.: No score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical15",1,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical15",2,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,null,0,null,0]
["Medical15",3,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},null,"Equip.: Does score…",null,0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical15",4,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical15",5,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical16",0,0,0,0,0,0,0,0,0,0,0,null,"Equip.: Does score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical16",1,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical16",2,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical16",3,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical16",4,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical16",5,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical17",0,0,0,0,0,0,0,0,0,0,0,null,"Equip.: Does score…",null,0,0,0,0,0,0,0,null,0,null,0]
["Medical17",1,0,0,0,0,0,0,0,0,0.035,{"v":1.0643500000000001,"d":"1.06"},{"$nulls":3},0,0,0,0,0,0,0,null,0.035,null,{"v":2.1,"d":"2"}]
["Medical17",2,0,0,0,0,0,0,0,0,{"v":0.08770000000000001,"d":"0.088"},{"v":2.6669570000000005,"d":"2.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.08770000000000001,"d":"0.088"},null,{"v":5.2620000000000005,"d":"5"}]
["Medical17",3,0,0,0,0,0,0,0,0,{"v":0.1747,"d":"0.175"},{"v":5.312627,"d":"5.31"}," ",null,null,0,0,0,0,0,0,0,null,{"v":0.1747,"d":"0.175"},null,{"v":10.482,"d":"10"}]
["Medical17",4,0,0,0,0,0,0,0,0,{"v":0.34600000000000003,"d":"0.346"},{"v":10.52186,"d":"10.52"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.34600000000000003,"d":"0.346"},null,{"v":20.76,"d":"21"}]
["Medical17",5,0,0,0,0,0,0,0,0,{"v":0.34600000000000003,"d":"0.346"},{"v":10.52186,"d":"10.52"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.34600000000000003,"d":"0.346"},null,{"v":20.76,"d":"21"}]
["Behavior1",0,0,0,0,0,0,0,0,0,0,0,"Supports - No Formal Plan",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Behavior1",1,0,0,0,0,0,0,0,0,{"v":0.4166666666666667,"d":"0.417"},{"v":12.670833333333334,"d":"12.67"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.4166666666666667,"d":"0.417"},null,25]
["Behavior1",2,0,0,0,0,0,0,0,0,{"v":1.6666666666666667,"d":"1.667"},{"v":50.68333333333334,"d":"50.68"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.6666666666666667,"d":"1.667"},null,100]
["Behavior1",3,0,0,0,0,0,0,0,0,{"v":2.8333333333333335,"d":"2.833"},{"v":86.16166666666668,"d":"86.16"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":2.8333333333333335,"d":"2.833"},null,170]
["Behavior1",4,0,0,0,0,0,0,0,0,{"v":2.8333333333333335,"d":"2.833"},{"v":86.16166666666668,"d":"86.16"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":2.8333333333333335,"d":"2.833"},null,170]
["Behavior1",5,0,0,0,0,0,0,0,0,{"v":2.8333333333333335,"d":"2.833"},{"v":86.16166666666668,"d":"86.16"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":2.8333333333333335,"d":"2.833"},null,170]
["Behavior2",0,0,0,0,0,0,0,0,0,0,0,"Support plans, Home & Comm.",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Behavior2",1,0,0,0,0,0,0,0,0,{"v":0.06578,"d":"0.066"},{"v":2.0003698,"d":"2.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.06578,"d":"0.066"},null,{"v":3.9468000000000005,"d":"4"}]
["Behavior2",2,0,0,0,0,0,0,0,0,{"v":0.06578,"d":"0.066"},{"v":2.0003698,"d":"2.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.06578,"d":"0.066"},null,{"v":3.9468000000000005,"d":"4"}]
["Behavior2",3,0,0,0,0,0,0,0,0,{"v":0.131536,"d":"0.132"},{"v":4.000009759999999,"d":"4.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.131536,"d":"0.132"},null,{"v":7.892159999999999,"d":"8"}]
["Behavior2",4,0,0,0,0,0,0,0,0,{"v":0.131536,"d":"0.132"},{"v":4.000009759999999,"d":"4.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.131536,"d":"0.132"},null,{"v":7.892159999999999,"d":"8"}]
["Behavior2",5,0,0,0,0,0,0,0,0,{"v":0.131536,"d":"0.132"},{"v":4.000009759999999,"d":"4.00"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.131536,"d":"0.132"},null,{"v":7.892159999999999,"d":"8"}]
["Behavior3",0,{"$f":"P195-(P195*$L$1)","v":0},{"$f":"Q195-(Q195*$L$1)","v":0},{"$f":"R195-(R195*$L$1)","v":0},{"$f":"S195-(S195*$L$1)","v":0},{"$f":"T195-(T195*$L$1)","v":0},{"$f":"U195-(U195*$L$1)","v":0},{"$f":"V195-(V195*$L$1)","v":0},{"$f":"W195-(W195*$L$1)","v":0},{"$f":"X195-(X195*$L$1)","v":0},{"$f":"K195*DaysPerMo","v":0},"Supervison, Home",null,null,0,0,0,0,0,0,0,null,{"$f":"$Y195+$Z195/60","v":0},null,0]
["Behavior3",1,0,0,0,0,0,0,0,0,{"v":0.9166666666666666,"d":"0.917"},{"v":27.875833333333333,"d":"27.88"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.9166666666666666,"d":"0.917"},null,55]
["Behavior3",2,0,0,0,0,0,0,0,0,{"v":3.3333333333333335,"d":"3.333"},{"v":101.36666666666667,"d":"101.37"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":3.3333333333333335,"d":"3.333"},null,200]
["Behavior3",3,0,0,0,0,0,0,0,0,{"v":4.666666666666667,"d":"4.667"},{"v":141.91333333333336,"d":"141.91"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":4.666666666666667,"d":"4.667"},null,280]
["Behavior3",4,0,0,0,0,0,0,0,0,{"v":4.666666666666667,"d":"4.667"},{"v":141.91333333333336,"d":"141.91"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":4.666666666666667,"d":"4.667"},null,280]
["Behavior3",5,0,0,0,0,0,0,0,0,{"v":4.666666666666667,"d":"4.667"},{"v":141.91333333333336,"d":"141.91"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":4.666666666666667,"d":"4.667"},null,280]
["Behavior4",0,0,0,0,0,0,0,0,0,0,0,"Supervision, Exclusive Focus",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Behavior4",1,0,0,0,0,0,0,0,0,{"v":1.5,"d":"1.50"},{"v":45.615,"d":"45.62"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.5,"d":"1.50"},null,90]
["Behavior4",2,0,0,0,0,0,0,0,0,{"v":3,"d":"3.00"},91.23,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":3,"d":"3.00"},null,180]
["Behavior4",3,0,0,0,0,0,0,0,0,{"v":4.5,"d":"4.50"},{"v":136.845,"d":"136.85"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":4.5,"d":"4.50"},null,270]
["Behavior4",4,0,0,0,0,0,0,0,0,{"v":6,"d":"6.00"},182.46,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":6,"d":"6.00"},null,360]
["Behavior4",5,0,0,0,0,0,0,0,0,{"v":7.5,"d":"7.50"},{"v":228.075,"d":"228.08"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":7.5,"d":"7.50"},null,450]
["Behavior4",6,0,0,0,0,0,0,0,0,{"v":9,"d":"9.00"},273.69,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":9,"d":"9.00"},null,540]
["Behavior4",7,0,0,0,0,0,0,0,0,{"v":9,"d":"9.00"},273.69,{"$nulls":3},0,0,0,0,0,0,0,null,{"v":9,"d":"9.00"},null,540]
["Social1",0,0,0,0,0,0,0,0,0,0,0,"Community Integration",null,null,0,0,0,0,0,0,0,null,0,null,0,"1-27-15 edited back to B values"]
["Social1",1,0,0,0,0,0,0,0,0,{"v":0.03333333333333333,"d":"0.033"},{"v":1.0136666666666667,"d":"1.01"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03333333333333333,"d":"0.033"},null,2,"all 3 socComm qu in B read"]
["Social1",2,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15,"off scoring for SocComm1"]
["Social1",3,0,0,0,0,0,0,0,0,{"v":0.8333333333333334,"d":"0.833"},{"v":25.34166666666667,"d":"25.34"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.8333333333333334,"d":"0.833"},null,50]
["Social1",4,0,0,0,0,0,0,0,0,{"v":1.6666666666666667,"d":"1.667"},{"v":50.68333333333334,"d":"50.68"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.6666666666666667,"d":"1.667"},1,{"v":40.00000000000001,"d":"40"}]
["Social1",5,0,0,0,0,0,0,0,0,{"v":1.8333333333333333,"d":"1.833"},{"v":55.751666666666665,"d":"55.75"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.8333333333333333,"d":"1.833"},1,{"v":49.99999999999999,"d":"50"}]
["Social2",0,0,0,0,0,0,0,0,0,0,0,"Social Interaction",null,null,0,0,0,0,0,0,0,null,0,null,0]
["Social2",1,0,0,0,0,0,0,0,0,{"v":0.03333333333333333,"d":"0.033"},{"v":1.0136666666666667,"d":"1.01"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03333333333333333,"d":"0.033"},null,2]
["Social2",2,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Social2",3,0,0,0,0,0,0,0,0,{"v":0.8333333333333334,"d":"0.833"},{"v":25.34166666666667,"d":"25.34"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.8333333333333334,"d":"0.833"},null,50]
["Social2",4,0,0,0,0,0,0,0,0,{"v":1.6666666666666667,"d":"1.667"},{"v":50.68333333333334,"d":"50.68"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.6666666666666667,"d":"1.667"},1,{"v":40.00000000000001,"d":"40"}]
["Social2",5,0,0,0,0,0,0,0,0,{"v":1.8333333333333333,"d":"1.833"},{"v":55.751666666666665,"d":"55.75"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.8333333333333333,"d":"1.833"},1,{"v":49.99999999999999,"d":"50"}]
["Social3",0,0,0,0,0,0,0,0,0,0,0,"Supervision, Community",null,null,0,0,0,0,0,0,0,null,0,null,0,"(Last question on sheet)"]
["Social3",1,0,0,0,0,0,0,0,0,{"v":0.03333333333333333,"d":"0.033"},{"v":1.0136666666666667,"d":"1.01"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.03333333333333333,"d":"0.033"},null,2]
["Social3",2,0,0,0,0,0,0,0,0,0.25,{"v":7.6025,"d":"7.60"},{"$nulls":3},0,0,0,0,0,0,0,null,0.25,null,15]
["Social3",3,0,0,0,0,0,0,0,0,{"v":0.8333333333333334,"d":"0.833"},{"v":25.34166666666667,"d":"25.34"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":0.8333333333333334,"d":"0.833"},null,50]
["Social3",4,0,0,0,0,0,0,0,0,{"v":1.6666666666666667,"d":"1.667"},{"v":50.68333333333334,"d":"50.68"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.6666666666666667,"d":"1.667"},1,{"v":40.00000000000001,"d":"40"}]
["Social3",5,0,0,0,0,0,0,0,0,{"v":1.8333333333333333,"d":"1.833"},{"v":55.751666666666665,"d":"55.75"},{"$nulls":3},0,0,0,0,0,0,0,null,{"v":1.8333333333333333,"d":"1.833"},1,{"v":49.99999999999999,"d":"50"}]

{"sheet":"Control","index":12,"n_rows":56,"n_cols":30,"rows_kept":56,"hidden":true}
[null,"Before-Save\nActive Sheet",null,"County/Brokerage LookUp",null,"Relationships",null,"Support Need Options - ADL","Support Need Options - Medical","Support Need Options - Nighttime","Documentation Needed Options","Support Need Options - Behavior","Documentation Needed Options - Behavior",null,"This\nTool-Type","Tool-Type\nIndex",null,"ANA\nService Settings","ANA\nSE Mapping","CNA\nService Settings","CNA\nSE Mapping",null,"SE No Options","ANA\nSE Non-Group Home","CNA\nSE Non-Group Home","CNA\nSE C-W Foster Care","SE Foster Care","ANA\nSE Group Home","CNA\nSE Group Home","SE Other"]
[null,"Client Demographics",null,"(Select)",null,"(Select)",null,"Independent","Independent","Independent","None","Not Applicable or Age-Appropriate Supervision","None",null,{"$f":"LEFT(TRIM(VersionDisplay), FIND(\" \",TRIM(VersionDisplay)) - 1)","v":"ANA"},{"$f":"IF(O2=\"ANA\",0,IF(O2=\"CNA\",1,\"#VALUE!\"))","v":0},null,"(Select)","SE_NoOptions","(Select)","SE_NoOptions",null,"(Select)","(Select)","(Select)","(Select)","Foster Care (SE 58)","24hr Residential (SE 50)","24hr Residential (SE 50)","(Explain in comment field of \"Summary of In-Home Hours\" sheet)"]
[{"$nulls":3},"Community Pathways",null,"Self",null,"Independent or Age Appropriate Supports Provided","Independent or Age Appropriate Supports Provided","Nighttime Assist - monthly","Caregivers' schedules and duties","Within Hearing or Visual Distance","OIS Training",{"$nulls":4},"Family Home","SE_NonGroupHome_ANA","Family Home","SE_NonGroupHome_CNA",null,null,"Comp In-Home (SE 49)","Child Long-term Support (SE 151)","Child Long-term Support (SE 151)",null,"SACU (SE 141)","Child Residential (SE 142)"]
[null,"Keep Current File Name",null,"CSI",null,"Legal Guardian",null,"Partial Assist","Individual-Directed Care","Nighttime Assist - weekly","Caregivers' schedules and duties, OIS IF-M Level training","Within Hearing and Visual Distance","Functional Assessment and Formal Behavior Support Plan",{"$nulls":4},"Own Home","SE_NonGroupHome_ANA","Child-welfare Foster","SE_CW_FosterCare",null,null,"Brokerage In-Home (SE 149)","CIIS (SE 145)","CIIS (SE 145)",null,null,"SACU (SE 141)"]
[null,true,null,"EOSSB",null,"Parent",null,"Partial Assist - assistance","Partial Assist","Nighttime Assist - intermittent nightly","Not Applicable","Redirecting","Functional Assessment and Formal Behavior Support Plan, OIS Training",{"$nulls":4},"Foster Care","SE_FosterCare","DD Foster","SE_FosterCare",null,null,"Supported Living (SE 51)",null,"Foster Care (SE 58)","^ NOTE: Shaded cell's named-range SE_FosterCare is also referenced by CNA's \"Summary of In-Home Hours\" sheet formula"]
[{"$nulls":3},"Full Access",null,"Provider/Staff",null,"Partial Assist - cueing","Partial Assist - 1 to 3 per day","Nighttime Assist - ongoing nightly",null,"Behavior Plan - No Physical Interventions","Functional Assessment and Formal Behavior Support Plan if indicated by the FA",{"$nulls":4},"24-hr. Group Home","SE_GroupHome_ANA","24-hr. Group Home","SE_GroupHome_CNA",null,null,"* BEWARE: Shaded cell is referenced by the \"New Scoring\" sheet",null,"* Shaded cell is same CNA value as SE_FosterCare so SE_FosterCare is referenced, for both cases, by CNA's \"Summary of In-Home Hours\" formula"]
[{"$nulls":3},"Full Access High Desert",null,"Behavior Specialist",null,"Partial Assist - food cut up","Partial Assist - weekly","Nighttime 1:1 Assist",null,"Behavior Plan - Physical Interventions","Functional Assessment and Formal Behavior Support Plan if indicated by the FA, Caregivers' schedules and duties",{"$nulls":4},"Other","SE_Other","Other","SE_Other"]
[{"$nulls":3},"Inclusion",null,"Nursing Professional",null,"Partial Assist - intermittent","Partial Assist and Monitoring","Nighttime 2:1 Assist",null,"Mental Health Plan",{"$nulls":5},"* NOTE: Shaded cells are named-ranges referenced by \"Summary of In-Home Hours\" sheet formula"]
[{"$nulls":3},"Ind NW",null,"Services Coordinator",null,"Partial Assist - physical","Full Assist","Not Applicable",null,"One-on-One"]
[{"$nulls":3},"ISN",null,"Regional MCL/Crisis Staff",null,"Partial Assist - some meals","Full Assist - 1 to 4",null,null,"One-on-One - 2"]
[{"$nulls":3},"Mentor Metro",null,"Child Welfare Staff",null,"Full Assist","Full Assist - 5 or 6",null,null,"One-on-One - 4"]
[{"$nulls":3},"Mid Valley",null,"SPD Kids’ Residential Coordinator",null,"Full Assist - constant","Full Assist - 7 or more",null,null,"One-on-One - 6"]
[{"$nulls":3},"RCO",null,"Other",null,"Full Assist - constant/aspiration risk","Full Assist - more than 3 per day",null,null,"One-on-One - 8"]
[{"$nulls":3},"SDRI",{"$nulls":3},"Two-Person Assist","Full Assist and Monitoring - exclusive focus",null,null,"One-on-One - 10"]
[{"$nulls":3},"SORB",{"$nulls":3},"Not Applicable","Delegated Nursing Tasks, < 50",null,null,"One-on-One - 12"]
[{"$nulls":3},"UCP",{"$nulls":4},"Delegated Nursing Tasks, >= 50",null,null,"Two-Person Assist"]
[{"$nulls":3},"-----------------------------",{"$nulls":4},"Direct Nursing by a Licensed Nurse",null,null,"Not Applicable"]
[{"$nulls":3},"BAKER",{"$nulls":4},"Two-Person Assist"]
[{"$nulls":3},"BENTON",{"$nulls":4},"Not Applicable",null,null,"Order?"]
[{"$nulls":3},"CLACKAMAS",{"$nulls":7},"Independent or Age Appropriate Supports Provided","?"]
[{"$nulls":3},"CLATSOP"]
[{"$nulls":3},"COLUMBIA"]
[{"$nulls":3},"COOS"]
[{"$nulls":3},"CROOK"]
[{"$nulls":3},"CURRY"]
[{"$nulls":3},"DESCHUTES"]
[{"$nulls":3},"DOUGLAS"]
[{"$nulls":3},"GILLIAM"]
[{"$nulls":3},"GRANT"]
[{"$nulls":3},"HARNEY"]
[{"$nulls":3},"HOOD RIVER"]
[{"$nulls":3},"JACKSON"]
[{"$nulls":3},"JEFFERSON"]
[{"$nulls":3},"JOSEPHINE"]
[{"$nulls":3},"KLAMATH"]
[{"$nulls":3},"LAKE"]
[{"$nulls":3},"LANE"]
[{"$nulls":3},"LINCOLN"]
[{"$nulls":3},"LINN"]
[{"$nulls":3},"MALHEUR"]
[{"$nulls":3},"MARION"]
[{"$nulls":3},"MORROW"]
[{"$nulls":3},"MULTNOMAH"]
[{"$nulls":3},"POLK"]
[{"$nulls":3},"SHERMAN"]
[{"$nulls":3},"TILLAMOOK"]
[{"$nulls":3},"UMATILLA"]
[{"$nulls":3},"UNION"]
[{"$nulls":3},"WALLOWA"]
[{"$nulls":3},"WASCO"]
[{"$nulls":3},"WASHINGTON"]
[{"$nulls":3},"WHEELER"]
[{"$nulls":3},"YAMHILL"]
[{"$nulls":3},"-----------------------------"]
[{"$nulls":3},"CIIS"]
[{"$nulls":3},"(Type in other…)"]